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

What is a shortcut and copy in Informatica and how two are different with each other?

1145


How do you load only null records into target?

1155


what is informatica metadata?

982


Differences between version 7.x and 8.x.

1852


Explain pushdown optimization $pushdownconfig parameter - informatica

1089


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1056


What is the need for an etl tool?

1020


How can you increase the performance in joiner transformation?

1149


Write the advantages of partitioning a session?

1222


Differentiate between source qualifier and filter transformation?

1521


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2199


What is the difference between informatica 7.0 and 8.0?

958


What is domain in terms of informatica?

965


What are the new features of informatica 9.x in developer level?

946


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

1864