select * from (select year, max(amount,quarter='first') q1

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 / hari

5 Answers
7957 Views
I also Faced
E-Mail Answers

Answer Posted / hari

select * from (select year,
max(amount,quarter='first') q1_amount,
max(amount,quarter='second') q3_amount,
max(amount,quarter='third') q4_amount,
max(amount,quarter='fourth') q4_amount
from table_name group by year );

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the measure objects?

1251

What is the need for an etl tool?

1100

What is InformaticaPowerCenter?

1177

Where are the source flat files kept before running the session?

1137

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1152

what is mean by complex business rule ?

2217

What is substr in informatica?

1259

Briefly explain the aggregator transformation?

1063

What the difference is between a database, a data warehouse and a data mart?

1197

EXL informatica Questions

1443

What is a filter transformation?

1089

What is joiner transformation in informatica?

1096

What is a repository? And how to add it in an informatica client?

1192

What is a pre-defined event and user-defined event?

1078

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2189