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
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is an expression transformation?
What is a dimensional model?
Why update strategy and union transformations are active? Explain with examples.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is workflow? What are the components of workflow manager?
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is $$$$?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is the maplet?
What are the differences between oltp and olap?
Informatica settings are available in which file?
How can we handle two sessions in informatica?
What is dimensional table? Explain the different dimensions.
What is meant by lookup transformation? Explain the types of lookup transformation?