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
Is it possible to define a single node as a Gateway node as well as worker node?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How do you promote a non-reusable transformation to reusable transformation?
What are the various types of transformation?
Explain the use of aggregator cache file?
What is incremental aggregation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
pmscmd startworkflow -sv
What do think which one is the better joiner or look up?
What is Index Caches size?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the new features of informatica 9.x at the developer level?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is a filter transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance