Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11033 Views
- HP, I also Faced
- E-Mail Answers
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
Explain how to import oracle sequence into informatica?
what is unit testing?tell me proceedure
Target increases every day even though no new record was inserted
can u any challenge your project?
How do you convert single row from source into three rows into target?
What is decode in static cache?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is domain and gateway node?
What is the fact table?
How do you use reject loader.
What is lookup transformation?
What can we do to improve the performance of informatica aggregator transformation?
How to configure mapping in informatica?
can u give example for factless fact table
Can anyone tell me the new features in Informatica 9 Version?
