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
- 8919 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What does command task mean?
What is repository manager?
What is meant by a domain?
What do you mean by blocking transformation?
What is the use of code page?
How can we create index after completion of load process?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is informatica powercenter repository?
Which is the t/r that builts only single cache memory?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Explain pmcmd command usage in informatica
Explain the features of connected and unconnected lookup.
How can we handle two sessions in informatica?
Enterprise data warehouse your projects phase by phase explain?
