Designer Guide

10.5.6
- 10.5
- 10.4.1
- 10.4.0

Back Next

Using the Slowly Changing Dimensions Wizard

The Slowly Changing Dimensions Wizard creates mappings to load slowly changing dimension tables:

Type 1 Dimension mapping.
Loads a slowly changing dimension table by inserting new dimensions and overwriting existing dimensions. Use this mapping when you do not want a history of previous dimension data.

Type 2 Dimension/Version Data mapping.
Loads a slowly changing dimension table by inserting new and changed dimensions using a version number and incremented primary key to track changes. Use this mapping when you want to keep a full history of dimension data and to track the progression of changes.

Type 2 Dimension/Flag Current mapping.
Loads a slowly changing dimension table by inserting new and changed dimensions using a flag to mark current dimension data and an incremented primary key to track changes. Use this mapping when you want to keep a full history of dimension data, tracking the progression of changes while flagging only the current dimension.

Type 2 Dimension/Effective Date Range mapping.
Loads a slowly changing dimension table by inserting new and changed dimensions using a date range to define current dimension data. Use this mapping when you want to keep a full history of dimension data, tracking changes with an effective date range.

Type 3 Dimension mapping.
Loads a slowly changing dimension table by inserting new dimensions and updating values in existing dimensions. Use this mapping when you want to keep the current and previous dimension values in the dimension table.

The following table describes the slowly changing dimension mapping types:

Slowly Changing Dimensions Mapping	Target Table	History	Data Handling
Type 1 Dimension	Slowly Changing Dimension	None	Inserts new dimensions. Overwrites existing dimensions with changed dimensions.
Type 2 Dimension/Version Data	Slowly Changing Dimension	Full	Inserts new and changed dimensions. Creates a version number and increments the primary key to track changes.
Type 2 Dimension/Flag Current	Slowly Changing Dimension	Full	Inserts new and changed dimensions. Flags the current version and increments the primary key to track changes.
Type 2 Dimension/Effective Date Range	Slowly Changing Dimension	Full	Inserts new and changed dimensions. Creates an effective date range to track changes.
Type 3 Dimension	Slowly Changing Dimension	Partial	Inserts new dimensions. Updates changed values in existing dimensions. Optionally uses the load date to track changes.

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Using the Slowly Changing Dimensions Wizard

Using the Slowly Changing Dimensions Wizard