Page History

3NF to Star Schema

Converts the 3rd Normal Form system model into a Star Schema with Facts, Dimensions, Surrogate keys and data lineage. By default, relies on the model being in a category (e.g. Physical) that contains an entity type of "Fact source" where the user will assign this entity type to entities that represent a "Fact" entity, usually the entities with the largest row count or several measuring attributes.

• Recommended Usage - Transitioning from "Physical" category to "Star schema" category.
• Where to From here - Apply model conversion "Generate Load and Stage tables".

3NF to Star Schema Views

Converts 3rd Normal Form tables into Dimensional star schema implemented via database views, often used for presentation layer virtualization. Similar to the purpose and behavior of the model conversion "3NF to Star Schema". The end result of the transformation results in the Facts and Dimensions to be Views.

• Recommended Usage - Transitioning from "Physical" category to "Star schema" category.
• Where to From here - Apply model conversion "Generate Load and Stage tables".

Create artificial keys

Transforms business relationships in a Star Schema model by copying the surrogate key attributes into the Fact Tables with an index and an artificial key relationship to the Dimension's surrogate key attribute.

• Recommended Usage - In the workflow of a "Star schema" category. Safe to re-apply.

Generate Load and Stage tables

Transforms a Star Schema model to generate the Stage and Load entities required for processing data and applying soft business rules.

• Recommended usage - Transitioning from "Star Schema" category to "Load and Stage" category.
• Where to from here - Run the Prepare for RED wizard.