I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

---

Define sessions in informatica etl?

0 Answers  

---

When do you use sql override in a lookup transformation?

0 Answers  

---

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

---

Write the advantages of partitioning a session?

0 Answers  

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

---

Why we use stored procedure transformation?

4 Answers  

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

---

How do you do error handling in Informatica?

1 Answers  

---