Dimensional Modeling

This section contains the following topics:

Overview of Documenting a Dimensional Model

Star Schema Design

Characteristics of a Star Schema

Fact Table

Dimensional Modeling Roles Assignments

Manually Assign Dimensional Modeling Roles

Conformance Warnings

Dimension Table

Overview of Large Dimension Tables Partitioning

Outrigger Table

Snowflake Schema

Convert an Entity Relationship Model to a Dimensional Model

Data Movement Rules