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


Please Help Members By Posting Answers For Below Questions

tell me the rules and responsblites in our project(my project is development)

1472


What the difference is between a database, a data warehouse and a data mart?

571


What is rank transformation in informatica

659


Explain about cumulative Sum or moving sum?

596


design of staging area?

1565






Can we get 1st record through Informatica(without sequence number).

940


What is InformaticaPowerCenter?

662


What is meant by pre and post session shell command?

598


How does a sorter cache works?

548


Differentiate between a database and data warehouse?

626


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1629


Plz can any one say me how to get the informatica certification materials and dumps

1571


scenario where i can use only concurrent execution of workflow.

2513


Explain the pipeline partition with real time example?

626


Explain the mapping variable usage example in informatica

609