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
Answer Posted / a
select yr,acc, max(decode (mon,'jan',am)) mon1,max(decode
(mon,'feb',am)) mon1,max(decode (mon,'mar',am)) mon1 from
intr
group by yr,acc
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is repository manager?
can u give example for factless fact table
What are the components of workflow manager?
What is informatica metadata and where is it stored?
What is the use of target designer?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How do you load only null records into target? Explain through mapping flow.
What is the format of informatica objects in a repository?
Design time, run time. If you don't create parameter what will happen
What happens when a session fails and you click on recover?
Describe expression transformation?
What is a snowflake schema?
What does role playing dimension mean?