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 / sehajshangari1235
TAKE A NORMALIZER TRANSFORMATION.
CREATE A NORMALIZED PORT NAMED "DETAIL" WITH OCCURENCE 4
.CONNECT INPUT PORTS FROM SOURCE QUALIFIER TO EACH DETAIL
PORT IN NORMALIZER.
NEXT TAKE AN EXPRESSION TRANSFORMATION.IN THAT CREATE AN
OUTPUT PORT NAMED MONTH.AN IN EXPRESSION EDITER WRITE THE
LOGIC AS
DECODE(GCID_DETAIL,1,'JAN',DECODE(GCID_DETAIL,2,'FEB',DECODE(
GCID_DETAIL,3,'MARCH','APRIL')))
CONNECT THIS OUTPUT PORT TO TARGET TABLE PORT!!!
SEHAJ
7204719446
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is an expression transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How can we update a record in the target table without using update strategy?
Can we get 1st record through Informatica(without sequence number).
Enlist the tasks for which source qualifier transformation is used.
What is the meaning of up gradation of repository?
What is Data Caches size?
What does update strategy mean, and what are the different option of it?
Which development components of informatica have the highest usage?
Explain the tuning lookup transformation - informatica
What is lookup change?
What does role playing dimension mean?
How to go to the older version for a mapping?
What are the databases that informatica can connect to windows?
What is the use of code page?