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 / prabhu
Source qualifier --> Normalizer --> Expr --> Agg --> target
In Normalizer give the four numeric values as input and then take numeric value and it's GK_value to expression.
In Expression i have made flag for month and hardcoding values of month
Flag_Jan --> IN(GK_Salary,1,5,9,0)
Flag_Feb --> in(GK_Salary,2,6,10,0)
Flag_Mar --> in(GK_Salary,3,7,11,0)
Month --> iif(Flag_Jan = 1,'Jan',iif(Flag_Feb = 1,'Feb',iif(Flag_Mar = 1,'Mar','Aprl')))
In agg group by on month and get sun(numeric value)
Pass month and sum(numeric) value to target
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
can u any challenge your project?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What do you mean by filter transformation?
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 can we use mapping variables in informatica? Where do we use them?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the difference between a repository server and a powerhouse?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is meant by pre and post session shell command?
Can you use flat files in Mapplets.
How many ways a relational source definition can be updated and what are they?
What is the difference between router and filter?
What is a repository? And how to add it in an informatica client?
Please let me know how to make encryption and decryption with example?
How to update or delete the rows in a target, which do not have key fields?