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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,


What is Target Update Override? What is the Use ?

8 Answers   Patni,


suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,


What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  


How we can create indexes after completing the loan process?

0 Answers  






How do you use reject loader.

0 Answers  


whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,


What is the surrogate key?

0 Answers  


what is dimension table?

17 Answers  


Define error Threshold?

1 Answers  


Write the different tools in the workflow manager?

0 Answers  


What is joiner transformation?

0 Answers  


Categories