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 / raj
sourcequalifier....>normalizer.....>expression...>aggrgater....>target
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Informatica Checkpoints
What is native users?
How does a rank transform differ from aggregator transform functions max and min?
Sequence generator, when you move from develoment to production how will you reset
differences between service based and product based?
What is intricate mapping?
What is the difference between Active and Passive transformation?
Why do you use Mapping Parameter and mapping variable?
What are the performance considerations when working with aggregator transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is update strategy transform?
What is InformaticaPowerCenter?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the Process to creating lookup transformation in informatica
What are the differences between joiner transformation and source qualifier transformation?