Select year, sum(case when quarter = 'first' then amount end) AS

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

5 Answers
7790 Views
I also Faced
E-Mail Answers

Answer Posted / qlikstar

Select year,
sum(case when quarter = 'first' then amount end) AS q1_amount,
sum(case when quarter = 'second' then amount end) AS q2_amount,
sum(case when quarter = 'third' then amount end) AS q3_amount,
sum(case when quarter = 'fourth' then amount end) AS q4_amount

from table
group by year order by year

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2370

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1917

Explain lookup transformation source types in informatica

1105

Can we change Dynamic to Static or Persistent cache? If so what happens?

2214

how to create user defined function (udf) in informatica

1315

What are roles and groups and benefits of using them?

1057

On which transformations you created partitions in your project?

1350

What is joiner change?

1151

Explain the features of connected and unconnected lookup.

937

Explain the scenario which compels informatica server to reject files?

1172

What are the different types of olap? Give an example?

1057

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5800

How to elaborate powercenter integration service?

1139

What are the modules in Power Center

1682

can we override a native sql query within informatica? Where do we do it?

1129