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
Can you use flat files in Mapplets.
What is meant by active and passive transformation?
What is decode in informatica?
What all join we can perform in LOOKUP transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How does the aggregator transformation handle null values?
Please let me know how to make encryption and decryption with example?
Define pmcmd command?
What the difference is between a database, a data warehouse and a data mart?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Performance tuning in UNIX for informatica mappings?
What will be the approach?
How can we use batches?
What is union transformation in informatica?
What is a passive transformation?