How many steps etl contains?
What is a mapping?
What are materialized views & where do we use them?
State the differences between shortcut and reusable transformation
Explain about round-robi?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is a materialized view log?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What are snapshots?
What are the differences between sql override and update override?
What is partitioning? Explain about round-robin, hash partitioning.
Explain about hash partitioning?
How many types of transformations supported by sorted input?
How to fine tune mappings?
What is a mapping, session, worklet, workflow, mapplet?