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 / siva

Please Explain me briefly. Thank You.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1529


What is lookup transformation?

612


COM components can be used in Informatica

1888


Explain the aggregator transformation?

642


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1539






what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1788


How can we improve session performance in aggregator transformation?

682


What is a grid in Informatica?

628


How do you remove duplicate records in informatica? And how many ways are there to do it?

726


What is an aggregator transformation?

624


can anyone explain me about retail domain project in informatica?

7447


what is the size of your data warehousing?

1683


Make a note of the quantity vaults made in informatica?

568


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

800


Differentiate between sessions and batches?

586