Converting Rows to columns
I have Relational source like his.
JAN FEB MAR APR
100 200 300 400
500 600 700 800
900 100 200 300
I need to convert these rows into columns to the targe.
MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500
Please experts help me
Answer Posted / chandu621
you will take Expression transfermation
and write expression like this
sum(months)
Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What is aggregate cache in aggregator transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
How to extract sap data using informatica? What is abap? What are idocs?
How does a sorter cache works?
What is the Process to creating lookup transformation in informatica
Why sorter is an active transformation?
Differentiate between Load Manager and DTM?
What are the different types of transformation available in informatica.
Difference between Target-based loading and constraint-based loading?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Differentiate between a database and data warehouse?
Explain the aggregator transformation?
What is meant by active and passive transformation?
How to join three sources using joiner? Explain though mapping flow.
Is it possible to create multiple domains on a single Informatica server?