how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,

---

What is meant by query override?

0 Answers  

---

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,

---

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

what is difference between COM & DCOM?

1 Answers   Satyam,

---

What is the difference between Normal load and Bulk load?

5 Answers  

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

Can u generate reports in Informatica?

0 Answers   Informatica,

---

What is the use of target designer?

0 Answers  

---

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,

---