I have source like this
year account month amount
----- --------- ------ --------
1999 salaries jan 9600
1999 salaries feb 2000
1999 salaries mar 2500
2001 benfits jan 3000
2001 benfits feb 3500
2001 benfits mar 4000
-->i need target like this
year account month1 month2 month3
----- --------- -------- -------- --------
1999 salaries 9600 2000 2500
2001 benfits 3000 3500 4000
Answer Posted / sai karthik
We can achieve this with Aggregator transformation.
SQ-->AGG-->TGT
IN AGGREGATOR TRANSFORMATION GROUP BY YEAR AND ACCOUNT PORTS
AND TAKE THREE OUTPUT PORTS 1. MONTH1, 2. MONTH2, 3. MONTH3 AND WRITE THESE FUNCTIONS.
1. MAX(DECODE(MONTH,'JAN',AMOUNT))
2. MAX(DECODE(MONTH,'FEB',AMOUNT))
3. MAX(DECODE(MONTH,'MAR',AMOUNT))
CONNECT THE PORTS TO THE TARGET AND RUN THE SESSION AND SEE THE RESULT.
CHEERS
SAI KARTHIK
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sq transformation?
What is the difference between a repository server and a powerhouse?
what are the deliverables?in your project?
What do mean by local and global repository?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How many dimensions are there in informatica?
What is a connected transformation?
What is joiner transformation in informatica?
can we override a native sql query within informatica? How do we do it?
What are the types of data warehouses?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to generate sequence numbers using expression transformation?
what is degenerated dimension?
Explain the use of aggregator cache file?