What are the steps involved in creating dimensional modeling process?
Explain what are the different methods of loading dimension tables?
What are the different types of datawarehosuing?
Explain me what are conformed dimensions?
Whether dimension table can have numeric value?
Explain how to export mappings to the production environment?
Define data warehouse?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain what is data validation strategies for data mart validation after loading process?
Explain why are oltp database designs not generally a good idea for a data warehouse?
What needs to be done when the database is shutdown?
Explain about core dimension, balanced dimension, and dirty dimension?
Can we have multiple application.cfm file in an application?
How to pivot row data using informatica?
What are the various methods of getting incremental records or delta records from the source systems?