Data Warehouse Architecture
Some Acronyms/Terms
Data Structures/Databases
Modeling Methods
Entity-Relationship Modeling
Dimensional Modeling
Dimensional Models
The “Cube”
Star Schema
Snowflake Schema
Dimension Tables
Dimension Tables (cont…)
Dimension Tables - Granularity
Dimension Tables - “Types”
Dimension Tables - Time
Dimension Tables - Degenerate
Dimension Tables - “Junk”
Fact Tables
Facts - Additive
Facts - Semi-additive/non-additive
Closing
Email: slavko-stemberger@home.com
Other information: Phone: (416)208-7847
Download presentation source