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 / chandra mouli
You will take Expression Transfermation.
In Expression Editon you can write lke this
sum(months) and group by month.
Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Why union transformation is an active transformation?
How many number of sessions can one group in batches?
If informatica has its scheduler why using third party scheduler?
What are the new features of informatica 9.x developer?
wf dont have integration severances how you can run?
How can we improve session performance in aggregator transformation?
Explain lookup transformation in informatica
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is a grid in Informatica?
What is the way to execute pl/sql script using informatica mapping?
Explain sessions and how many types of sessions are there?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Is it possible to revert a global repository to local one and why?
What are the different ways to implement parallel processing in informatica?
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.