Datawarehouse/DW Interview Questions

Datawarehouse/DW Interview Questions

• Explain about Data warehousing concepts?
• Star schema and snow flake schema?
• Explain the structure of Fact & Dimensions tables
• Difference between OLTP & OLAP
• Explain about MOLAP , ROLAP, HOLAP
• Have you ever worked on Data modeling?
• Difference between STAR & SNOWFLAKE Schema
• Briefly explain about DATA MARTS
• What are Early arriving facts, late arriving dimensions?
• Cascading parameters?
• Types of dimensions & Facts?
• Degeneration dimensions?
• What is Fact less facts & Junk dimension?