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
- 9057 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
What is the maplet?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Can we create two repositories on same database instance in oracle?
What is workflow manager?
What is the difference between STOP and ABORT options in Workflow Monitor?
How to improve the performance of a session using sorter transformation?
What are the new features of informatica 9.x at the developer level?
without table how to come first record only in oracle?
How to create or import flat file definition in to the warehouse designer?
What is aggregate cache in aggregator transformation?
What are the types of schemas we have in data warehouse.
Define mapping and session?
Can you generate sequence numbers without using the sequence generator transformation?
What is the status code in stored procedure transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
