Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Using the Slowly Changing Dimensions Wizard

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.


Updated June 25, 2018