Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c
i want output as 1 a,b,c and 2 a,b,c ...
how can achieve this

Answer Posted / ganesh yadav

using Normalizer Transformation we can convert the multiple
columns as multiple rows, multiple rows as multiple columns...
rows: 1 1 1 2 2 2
a b c a b c
answer
column wise
1 a b c
2 a b c

Is This Answer Correct ?    3 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to import oracle sequence into informatica?

1071


How many types of sessions are there in informatica.please explain them?

1210


Define mapping and session?

1091


Please let me know how to make encryption and decryption with example?

1950


What are the different types of olap? Give an example?

1098


How do you load first and last records into target table?

1209


What do you understand by a term domain?

1173


What is the status code in stored procedure transformation?

1234


What is the scenario which compels informatica server to reject files?

1123


What is a joiner transformation?

1037


What is expression transformation?

1146


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1727


What is the difference between Active and Passive transformation?

1223


Explain load alternative records / rows into multiple targets - informatica

1206


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8265