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
- 9037 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
In informatics server which files are created during the session rums?
Where do we use mapping variables in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How many numbers of sessions can one group in batches?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is the scenario which compels informatica server to reject files?
How can we store previous session logs?
How can you define user defied event?
How can we use batches?
What is a mapplet/worklet in informatica?
How can a transformation be made reusable?
How can informatica be used for an organization?
How many ways are there to create ports?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Plz can any one say me how to get the informatica certification materials and dumps
