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
- 8873 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
What is the scenario which compels informatica server to reject files?
What do you mean by channel change?
what is SDLC way of code development?
What does reusable transformation mean?
What is the function of aggregator transformation?
What do you mean by blocking transformation?
r u done any partitions in ur project?
What are the differences between source qualifier and joiner transformation?
Explain the different lookup methods used in informatica?
What is sq transformation?
Separate from a database, an information bazaar, and an information stockroom?
Explain the different kinds of facts.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
what is song in infrmatica...?
