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

Write the unconnected lookup syntax?

1077


What all are steps in up gradation of Informatica server?

1041


What is a predefined event?

1085


State the limitations where we cannot use joiner in the mapping pipeline?

1054


What are the popular informatica products?

1006


wat are deployement groups in informatica, how it will be used for developers

1709


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1617


What are the tasks that can be performed using sq?

1083


Whats the difference between informatica powercenter server, repositoryserver and repository?

1168


How to load the data from a flat file into the target where the source flat file name changes daily?

1047


What is rank index in rank transformation?

1066


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1572


How would you join a node to the already existing domain?

1117


What is informatica? Why do we need it?

1087


Describe expression transformation?

1112