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
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is depict expression change?
How many ways are there to create ports?
Tell me about Propagate functions in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the commit type if you have a transaction control transformation in the mapping?
What all join we can perform in LOOKUP transformation?
How can we use mapping variables in informatica?
What is the use of an aggregator cache file?
What is xml source qualifier transformation in informatica?
What are ETL Tools?
Where are the source flat files kept before running the session?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?