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 / shankar
source qualifier > expression <for best practice> > aggregator > normalizer . target.
here in this the SQ will be for relational & flat files, then we use expression for best practice, in this we take the ports which we need into target also we can rename the ports for our convenience just to avoid confusion.
Then for calculating totals we use aggregator.
to convert the rows to col we use the normalizer. This is to my knowledge. Thank you if wrong pls post.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
In which transformation you cannot drag ports into it?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is InformaticaPowerCenter?
what is $$$$?
As union transformation gives UNION ALL output, how you will get the UNION output?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is informatica worklet?
Differentiate between a repository server and a powerhouse?
Why filter transformation is an active one?
On which transformations you created partitions in your project?
Separate from a database, an information bazaar, and an information stockroom?
What is DR strategy for Informatica project?
Explain joiner transformation in informatica
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?