Interested to Buy Any Domain ? << Click Here >> for more details...
write sql query following table
amount year quarter
1000 2003 first
2000 2003 second
3000 2003 third
4000 2003 fourth
5000 2004 first
6000 2004 second
7000 2004 third
8000 2004 fourth
i want the output
year q1_amount q2_amount q3_amount q4_amount
2003 1000 2000 3000 4000
2004 5000 6000 7000 8000
can anybady help me to achieve the aboue result by using informatica.
thanks in advance.
- 5 Answers
- 7559 Views
- I also Faced
- E-Mail Answers
Answer Posted / kamleshmishra291
SQL OVERRIDE :
SELECT * FROM TABLE_NAME PIVOT(MAX(AMOUNT) FOR QUARTER IN ('FIRST','SECOND','THIRD','FOURTH'));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a filter transformation?
What is the sequence generator transformation in informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are multi-group transformations?
How many input parameters can exist in an unconnected lookup?
What are the types of presistent cache in look up tr.
Briefly define a session task?
without table how to come first record only in oracle?
What is a repository? And how to add it in an informatica client?
According to his methodology what all you need before you build a datawarehouse
What is a code page?
What are the modules in Power Center
can we override a native sql query within informatica? Where do we do it? How do we do it?
Which is the t/r that builts only single cache memory?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
