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
- 8887 Views
- HCL, I also Faced
- E-Mail Answers
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
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
wf dont have integration severances how you can run?
Mention few advantages of router transformation over filter transformation.
How do you use reject loader.
Separate from an archive server and a powerhouse?
What are some examples of informatica etl programs?
what is mean by complex business rule ?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the main issues while working with flat files as source and as targets ?
How we can use union transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is update strategy transform?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Under what conditions selecting sorted input in aggregator will still not boost session performance?
how tokens will generate?
