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
What are connected or unconnected transformations?
Mention a few design and development best practices for informatica?
explain abt ur project architecture?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are active and passive transformations?
Repository user profiles
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is a difference between complete, stop and abort?
What is source qualifier transformation in informatica?
Define mapplet?
Explain the different dimensions.
can we override a native sql query within informatica? Where do we do it? How do we do it?
Why filter transformation is an active one?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is persistent lookup cache?