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/

Define Pmrep command?

1116

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2249

---

What is the status code in stored procedure transformation?

1236

---

What is standalone command task?

1376

---

What is workflow? What are the components of workflow manager?

1235

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2129

---

What is meant by query override?

1118

---

What is the scenario which compels informatica server to reject files?

1124

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10729

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8265

---

differences between service based and product based?

2060

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2190

---

What is an aggregator transformation?

1148

---

What does update strategy mean, and what are the different option of it?

1143

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250

---