Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 9040 Views
- HCL, I also Faced
- E-Mail Answers
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
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the use of an aggregator cache file?
Differentiate between a database and data warehouse?
What is a surrogate key?
What is data movement mode in Informatica and difference between them?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
explain about unit testing? in real time?
What differs when we choose the sorted input for aggregator transformation?
Explain the difference between mapping parameter and mapping variable?
Differentiate between Load Manager and DTM?
What is a transaction control transformation?
what is informatica metadata?
How to configure mapping in informatica?
Different sorts of metadata that stores in the storage facility?
What is a grid in Informatica?
