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/

Explain direct and indirect flat file loading (source file type) - informatica

1356

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7365

---

What are the modules in Power Center

1718

---

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

1197

---

Define pmcmd command?

1103

---

What is standalone command task?

1369

---

What is a node in Informatica?

1084

---

What are the types of caches in lookup? Explain them.

1009

---

What is session task and command task?

1391

---

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

1182

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2182

---

Explain the pipeline partition with real time example?

1198

---

What are the various types of transformation?

1239

---

Explain the etl program with few examples.

1113

---

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

2185

---