As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

---

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

Explain lookup transformation source types in informatica

0 Answers   Informatica,

---

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

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 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

---

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

7 Answers   Cap Gemini,

---

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

---

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---