In how many ways we can create ports?
How to generate sequence numbers?
What is the need of etl tools?
Explain sessions and how many types of sessions are there?
What is different between the data warehouse and data mart?
What is the fact table?
What is data caches/ index caches?
What do you mean by blocking transformation?
What are batches?
How many dimensions are there in informatica?
Explain what transformation and how many are there in informatica?
What are the static cache and dynamic cache in informatica?
How to delete duplicate row using informatica?
How can you generate reports in informatica?
Can you generate sequence numbers without using the sequence generator transformation?