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/

where to store informatica rejected data? How to extract the informatica rejected data?

1005

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2518

---

How would you join a node to the already existing domain?

1130

---

How many ways are there to create ports?

1332

---

What is dynamic cache?

1034

---

What is session task and command task?

1296

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2158

---

What is the different lookup cache(s)?

1086

---

What is parallel processing in informatica?

1714

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

---

Define the various join types of joiner transformation?

988

---

r u done any partitions in ur project?

1827

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1901

---

Explain the types of lookup transformation?

1045

---

What is sequence generator transformation in informatica?

1079

---