⟩ What are Fact, Dimension, and Measure?
Fact is key performance indicator to analyze the business. Dimension is used to analyze the fact. Without dimension there is no meaning for fact.
Fact is key performance indicator to analyze the business. Dimension is used to analyze the fact. Without dimension there is no meaning for fact.
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?
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?