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
- 8929 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / soumen
Use following method --
sq_source --> exp_tans --> agg_trans --> target
exp_trans --> add 3 variable --
v_month1 == iif(month='jan', amount, 0)
v_month2 == iif(month='feb', amount, 0)
v_month3 == iif(month='mar', amount, 0)
agg_trans --> add 5 cols from exp_trans --
year(check group by), account(check group by), v_month1,
v_month2, v_month2
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / soumen
Little corrections ---->
Use following method --
sq_source --> exp_tans --> agg_trans --> target
exp_trans --> add 3 variable --
v_month1 == iif(month='jan', amount, 0)
v_month2 == iif(month='feb', amount, 0)
v_month3 == iif(month='mar', amount, 0)
agg_trans --> add 5 cols from exp_trans --
year(check group by), account(check group by), sum(v_month1),
sum(v_month2), sum(v_month2)
Now forward these 5 cols to Target.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
why we use informatica in our project?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
what is threshold error in informatica?
can any one explain me about junk dimension
who is the best faculty for informatica in hyderabad ameerpet?
If we are using an aggregator but forget to mention the group by port .what will be the output??
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
Which tool yoU use to create and manage sessions and batches and to monitor and stop the informaticaserver?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Teradata 
