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
- 6675 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 are batches?
Can you use flat files in Mapplets.
In warehouses how many schemas are there?
Enlist the tasks for which source qualifier transformation is used.
in reporting we add some new objects,how we get the count of the newly added objects to the report
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How do you load unique records into one target table and duplicate records into a different target table?
What is update strategy transform?
Explain why we use partitioning the session in informatica?
Explain the different lookup methods used in informatica?
What are the prerequisite tasks to achieve the session partition?
Write the different tools in the workflow manager?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
In how many ways we can create ports?
What is workflow monitor?
