Data Warehouse Interview Questions and Answers

Data Warehouse interview questions - These Data Warehouse questions have been designed to help you improve your skills to face interview questions on Data Warehouse. All freshers, BCA, BE, BTech, MCA and college students wanting to make a career in Data Warehouse will be highly benefited by these questions.


  • In this video, following interesting questions have been covered that might be asked in Data warehouse interview

    1. What is a Data Warehousing? How Data Warehouse works?
    2. What is Business Intelligence?
    3. What is ETL?
    4. What is Fact and Dimension in Data Warehouse?
    5. Compare Database and Data Warehouse Utility
    6. What do you understand by dimensional modeling?
    7. What is Fact Table? What is Dimension table?
    8. What is the difference between ER Modeling and Dimensional Modeling?
    9. What is Data Mining?
    10. What is the difference between view and materialized view?
    11. What is the main difference between Star and Snowflake Star Schema?
    - Rhea Jain - (21 Feb 2020)