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
Briefly describe lookup transformation?
What are the tuning techniques you applied during your last project
Under what conditions selecting sorted input in aggregator will still not boost session performance?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Can u generate reports in Informatica?
What is persistent lookup cache?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Partition, what happens if the specified key range is shorter and longer
What are the tasks that can be performed using sq?
How to use procedural logic inside infromatica?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Explain the features of connected and unconnected lookup.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is a passive transformation?
What is a snowflake schema?