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
- 8732 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 is the advantage of informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How can we store previous session logs?
What can we do to improve the performance of informatica aggregator transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Target increases every day even though no new record was inserted
Describe the impact of several join conditions and join order in a joiner transformation?
What is workflow monitor?
How an expression transformation differs from aggregator transformation?
What is powercenter on grid?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
During the running session, output files are created by informatica server. Enlist few of them.
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain about Informatica server process that how it works relates to mapping variables?
