write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

if i am having 10 records in source, i want 20 records in target...how will you do it

13 Answers   BirlaSoft, IBM,

---

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

---

Could you explain what is enterprise data warehouse?

0 Answers  

---

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

---

What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,

---

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

---

What is informatica? Why do we need it?

0 Answers  

---

What is power play plug in?

2 Answers  

---

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

0 Answers  

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

---