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
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is exclusive and normal mode for repository services?
Whats there in global repository
Explain pushdown optimization $pushdownconfig parameter - informatica
Informatica Checkpoints
Global and Local shortcuts. Advantages.
is it possible to index the data in cache of lkp transformation ?
What are the types of caches in lookup? Explain them.
Plz can any one say me how to get the informatica certification materials and dumps
What is a difference between complete, stop and abort?
What is enterprise data warehousing?
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
How to use procedural logic inside infromatica?
What do you understand by term role-playing dimension?
Make a note of the quantity vaults made in informatica?