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
- 8 Answers
- 8846 Views
- HP, I also Faced
- E-Mail Answers
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 the way to execute pl/sql script using informatica mapping?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the difference between writing a joiner query in ANSI style and THETA style?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
tell me about your project functionality
What is expression transformation?
How to generate sequence numbers using expression transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
Write the advantages of partitioning a session?
Describe expression transformation?
What does reusable transformation mean?
What are active transformations.
Make a note of the quantity vaults made in informatica?
list out all the transformations which use cache?
What is a sequence generator transformation?
