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
tell me the rules and responsblites in our project(my project is development)
What the difference is between a database, a data warehouse and a data mart?
What is rank transformation in informatica
Explain about cumulative Sum or moving sum?
design of staging area?
Can we get 1st record through Informatica(without sequence number).
What is InformaticaPowerCenter?
What is meant by pre and post session shell command?
How does a sorter cache works?
Differentiate between a database and data warehouse?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Plz can any one say me how to get the informatica certification materials and dumps
scenario where i can use only concurrent execution of workflow.
Explain the pipeline partition with real time example?
Explain the mapping variable usage example in informatica