Top data warehousing interview questions
- What is the data type of the surrogate key?
- What are the steps to build the data warehouse?
- What are the different architectures of data warehouse?
- What are the advantages data mining over traditional approaches?
- What is the difference between view and materialized view?
- What is the main difference between Inmon and Kimball philosophies of data warehousing?
- What is junk dimension? what is the difference between junk dimension and degenerated dimension?
- What is the definition of normalized and denormalized view and what are the differences between them
- Why fact table is in normal form?
- What is Difference between E-R Modeling and dimensional modeling.
- What is conformed fact?
- What are the methodologies of Data Warehousing.
- What is BUS Schema?
- What is Datawarehousing Hierarchy?
- What is data validation strategies for data mart validation after loading process
- What is a linked cube?
- What is meant by metadata in context of a Datawarehouse and how is it important?
- What is incremental loading?
- What is batch processing?
- What is cross-reference table?
- What is aggregate fact table?
- What are the possible data marts in Retail sales?
- What is the main difference between schema in RDBMS and schemas in DataWarehouse?
- What are the various ETL tools in the Market?
- What is Dimensional Modelling?
- What is VLDB?
- What is degenerate dimension table?
- What is ER Diagram?
- Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
- What is a CUBE in data warehousing concept?
- Differences between star and snowflake schemas?
- What are Datamarts?
- Can a dimension table contains numeric values?
- What is hybrid slowly changing dimension?
