Answer Posted / ankit kansal

The above answer is perfectly fine, however you can achieve the same using case

Select YEAR,SUM(q1_amt)q1_amt,SUM(q2_amt)q2_amt,SUM(q3_amt)
q3_amt,SUM(q4_amt)q4_amt from (
select YEAR,
CASE QUARTER WHEN 'first' THEN amount ELSE 0 END as q1_amt,
CASE QUARTER WHEN 'second' THEN amount ELSE 0 END as q2_amt,
CASE QUARTER WHEN 'third' THEN amount ELSE 0 END as q3_amt,
CASE QUARTER WHEN 'fourth' THEN amount ELSE 0 END as q4_amt
from t_name) temp group by YEAR;

http://deepinopensource.blogspot.in/

What is union transformation in informatica?

1096

---

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

2319

---

Explain constraint based loading in informatica

1035

---

How to do unit testing in informatica? How to load data in informatica ?

1045

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6909

---

Explain why we use partitioning the session in informatica?

1005

---

How to load data in informatica ?

952

---

What is rank transform?

940

---

What is the procedure for creating independent data marts from informatica 7.1?

997

---

Differentiate between joiner and lookup transformation?

1045

---

What are data-driven sessions?

1142

---

What are the differences between a connected lookup and unconnected lookup?

1014

---

What is persistent lookup cache?

965

---

can anyone explain me about retail domain project in informatica?

7889

---

Explain your project of banking domian.

1605

---