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 / reddy

Answer:

Source --> Source qualifier --> Normalizer --> Expr -->
Agg --> target

Step 1:

Source --> Source qualifier --> Normalizer --> Expr -->

Expression Condition:

DECODE(GCID_DETAIL,1,'JAN',DECODE(GCID_DETAIL,2,'FEB',DECODE
(
GCID_DETAIL,3,'MARCH','APRIL')))


JAN 100
JAN 500
JAN 900
FEB 200
FEB 600
FEB 100
MAR 300
MAR 700
MAR 200
APR 400
APR 800
ApR 300

Step 2:

Source --> Source qualifier --> Normalizer --> Expr -->
Agg --> target

1) Group by month
2) Sum(Amount)

MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are factless facts? And in which scenario will you use such kinds of fact tables.

1287


What is exclusive and normal mode for repository services?

688


Whats there in global repository

1244


Explain pushdown optimization $pushdownconfig parameter - informatica

670


 Informatica Checkpoints

2833






Global and Local shortcuts. Advantages.

1438


is it possible to index the data in cache of lkp transformation ?

1501


What are the types of caches in lookup? Explain them.

520


Plz can any one say me how to get the informatica certification materials and dumps

1573


What is a difference between complete, stop and abort?

617


What is enterprise data warehousing?

591


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

1709


How to use procedural logic inside infromatica?

606


What do you understand by term role-playing dimension?

546


Make a note of the quantity vaults made in informatica?

529