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
- 11066 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
How many transformations can be used in mapplets.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is DR strategy for Informatica project?
According to his methodology what all you need before you build a datawarehouse
How do you promote a non-reusable transformation to reusable transformation?
How to elaborate powercenter integration service?
Why filter transformation is an active one?
What is data caches/ index caches?
how tokens will generate?
Explain how many types of dimensions are available in informatica?
what is the size of u r source(like file or table)?
How to differentiate between the active and passive transformations?
How can we improve session performance in aggregator transformation?
Could you explain what is enterprise data warehouse?
Explain the different kinds of facts.
