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
- 6344 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
tell me 5 session failure in real time how can you solve that in your project?
How to load data in informatica ?
What are the uses of etl tools?
wf dont have integration severances how you can run?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Design time, run time. If you don't create parameter what will happen
How do you set a varible in incremental aggregation
Under what condition selecting sorted input in aggregator may fail the session?
How to partition the Session?
What is Session and Batches?
What are the various types of transformation?
What are the settings that you use to configure the joiner transformation?
What are the different types of repositories created using informatica?
What is a code page?
What are the transformations that are not supported in mapplet?
