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?
