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
- 7705 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
Is there any way to read the ms excel datas directly into informatica?
what is the Default Source Option For Update Strategy Transformation?
What is the sql query overwrite in source qualifier in informatica
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?
explain one complex mapping with logic? sales project?
How to join three sources using joiner? Explain though mapping flow.
Write the unconnected lookup syntax and how to return more than one column.
Explain the different dimensions.
hi real timers . iam waiting for ur reply regarding ETL TESTING
Define the various join types of joiner transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain what is informatica metadata and where is it stored?
What is a rank transform?
What is workflow? What are the components of the workflow manager?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
