How to convert multiple rows to single row (multiple columns) in informatica


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  


what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,


What is transformation?

0 Answers  


what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,


Differentiate between reusable transformation and mapplet.

0 Answers  






sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  


In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,


Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,


What is the difference between a repository server and a powerhouse?

0 Answers  


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  


In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  


what is data driven?

5 Answers   TCS, Wipro,


Categories