Every dimension is represented with only one table
Connects to the fact table using the PK-FK
Dimension tables are independent
Dimension tables are Non-Normalized (e.g. Customer has customer and location data)
Fact table include key and measures
Uses more space
Higher Performance
Extends the Star Schema
Each Dimension table is further normalized
Uses smaller disk space
Lower performance
Last updated 3 years ago
