how can we convert a column into row in informatica?
Eg: INPUT- a x Output Like: a b c
b y x y z
c z

Answer Posted / lv

src--agg--exp--exp--jnr--tgt

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is workflow? What are the components of workflow manager?

708


Separate from a database, an information bazaar, and an information stockroom?

605


What is an unconnected transformation?

659


When do you use sql override in a lookup transformation?

582


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1621






Why filter transformation is an active one?

561


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1695


What is a node in Informatica?

619


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1730


Which transformation should we use to normalise the COBOL and relational sources?

738


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1513


What is olap (on-line analytical processing?

637


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1027


What are the differences between source qualifier and joiner transformation?

594


What are the components of the workflow manager?

635