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 a filter transformation?
Define enterprise data warehousing?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What do you mean by enterprise data warehousing?
tell me 5 session failure in real time how can you solve that in your project?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
how tokens will generate?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What differs when we choose the sorted input for aggregator transformation?
Explain lookup transformation in informatica
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How to extract sap data using informatica? What is abap? What are idocs?
explain abt ur project architecture?
What are the differences between joiner transformation and source qualifier transformation?
What is difference between a gateway node and worker node?