write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

What is the difference between Active and Passive transformation?

0 Answers   Informatica,

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  

---

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

---

---

Different types of Power center errors?

1 Answers   Cinterco, IBM,

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

What is polling?

1 Answers  

---

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

---

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

---

In joiner, how to load Master table in Target?

2 Answers  

---

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

---