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 / sham
we can't sum aggregate function in Exp T/F.i.e it is not
possible to use sum() in expression T/F. so go through Agg T/F
....
Group by month
o/p port-------> sum(sal)
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is resilience time?
How can informatica be used for an organization?
What can we do to improve the performance of informatica aggregator transformation?
What are the new features of informatica 9.x at the developer level?
What are the informatica performance improvement tips
What is the difference between informatica 7.0 and 8.0?
To import the flat file definition into the designer where should the flat file be placed?
What is enterprise data warehousing?
How to start a workflow using pmcmd command?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How to update a particular record in target with out running whole workflow?
Can we create two repositories on same database instance in oracle?
What are the limitations of joiner transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to improve the performance of a session using sorter transformation?