One way of doing it is simple using aggregate function. select year,sum(

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 / ankit kansal

5 Answers
7625 Views
I also Faced
E-Mail Answers

Answer Posted / ankit kansal

One way of doing it is simple using aggregate function.

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 test group by year;

http://deepinopensource.blogspot.in/

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Whats there in global repository

1653

Implementation methodology

1672

Explain the shared cache and re-cache?

1076

Explain transaction control transformation in informatica

1229

What is an expression transformation in informatica?

984

Can we create a Integration service without a Repository service and vice versa?

1191

How to handle decimal places while importing a flatfile into informatica?

1155

What is expression transformation?

1060

Scheduling properties,whats the default (sequential)

1916

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

2108

Differences between version 7.x and 8.x.

1864

How to load data in informatica ?

973

what is INFORMATICA TESTING process

2253

What are the new features of informatica 9.x in developer level?

960

What do you understand by a term domain?

1090