Original post for Data warehouse schema design - dimensional modeling and star schema in my blog
Introduction to data warehouse schema design: In this talk, I walk through the basics of dimensional design using the kimball group approach.
Amongst other things, I cover:
- OLAP systems vs OLTP systems
- Third normal form of operational DB
- What is a dimension
- What is a fact
- Star schema
- Dimension grain
- Surrogate keys
- Slowly changing dimensions
Latest comments (0)