⟩ What are the different types of data warehousing?
Types of data warehousing are:
1. Enterprise Data warehousing
2. ODS (Operational Data Store)
3. Data Mart
Types of data warehousing are:
1. Enterprise Data warehousing
2. ODS (Operational Data Store)
3. Data Mart
Explain What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain Is there any way to read the MS Excel Datas directly into Informatica?Like IS there any Possibilities to take excel file as target?
Explain What are the various methods of getting incremental records or delta records from the source systems?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA?
Explain the different Lookup methods used in Informatica?
Explain When do we Analyze the tables? How do we do it?
Suppose we have some 10,000 odd records in source system and when load them into target.How do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain What are the different versions of Informatica?
How can we determine what records to extract?
Explain What is a three tier data warehouse?