SQL OVERRIDE : SELECT * FROM TABLE_NAME PIVOT(MAX(AMOUNT) FOR QUARTER IN

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.

Question Posted / kamleshmishra291

5 Answers
7958 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

Please Help Members By Posting Answers For Below Questions

Scheduling properties,whats the default (sequential)

2007

What is transformation?

1157

How to start a workflow using pmcmd command?

1303

what is the size of u r source(like file or table)?

2306

Explain what are the different versions of informatica?

1143

Explain pushdown optimization and types in informatica

1122

What are mapplets?

1324

r u done any partitions in ur project?

1862

Explain lookup transformation in informatica

1123

What is the difference between writing a joiner query in ANSI style and THETA style?

2432

What is xml source qualifier transformation in informatica?

1276

What do you mean by blocking transformation?

1115

What is workflow manager?

1098

Clarify the utilization of aggregator cache record?

1042

How to improve the performance of a session using sorter transformation?

1186