⟩ What are Data Marts?
A data mart is a collection of tables focused on specific business group/department. It may have multi-dimensional or normalized. Data marts are usually built from a bigger data warehouse or from operational data.
A data mart is a collection of tables focused on specific business group/department. It may have multi-dimensional or normalized. Data marts are usually built from a bigger data warehouse or from operational data.
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?
Explain Where do we use semi and non additive facts?
Explain the process of extracting data from source systems,storing in ODS and how data modeling is done?
Explain What is the difference between Power Center & Power Mart?
Explain What are the various transformation available?
Tell me what is Full load & Incremental or Refresh load?