Previous Topic: Creating a Dimensional ModelNext Topic: Overview of Documenting a Dimensional Model


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