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
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Can we override a native sql query within informatica?
What are the new features of informatica 9.x developer?
How can a transformation be made reusable?
What is different between the data warehouse and data mart?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How can informatica be used for an organization?
How to update a particular record in target with out running whole workflow?
What is the difference between informatica 7.0 and 8.0?
What is fact table? Explain the different kinds of facts.
what is informatica metadata?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is the scenario which compels informatica server to reject files?
Describe expression transformation?