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. Appendix A: Datatype Reference
  17. Appendix B: Configure the Web Browser

Designer Guide

Designer Guide

Steps to Create a Type 2 Dimension/Effective Date Range Mapping

Steps to Create a Type 2 Dimension/Effective Date Range Mapping

To create a Type 2 Dimension/Effective Date Range mapping:
  1. In the Mapping Designer, click Mappings > Wizards > Slowly Changing Dimensions.
  2. Enter a mapping name and select Type 2 Dimension. Click Next.
    The naming convention for mappings is m_
    MappingName
    .
  3. Select a source definition to be used by the mapping.
    All available source definitions appear in the Select Source Table list. This list includes shortcuts, flat file, relational, and Application sources.
  4. Enter a name for the mapping target table. Click Next.
    The naming convention for target definitions is T_
    TARGET_NAME
    .
  5. Select the column or columns you want to use as a lookup condition from the Target Table Fields list and click Add.
    The wizard adds selected columns to the Logical Key Fields list.
    The columns you select should be a key column in the source.
    When you run the session, the Integration Service performs a lookup on existing target data. The Integration Service returns target data when Logical Key Fields columns match corresponding target columns.
    To remove a column from Logical Key Fields, select the column and click Remove.
  6. Select the column or columns you want the Integration Service to compare for changes, and click Add.
    The wizard adds selected columns to the Fields to Compare for Changes list.
    When you run the session, the Integration Service compares the columns in the Fields to Compare for Changes list between source rows and the corresponding target rows. If the Integration Service detects a change, it marks the row changed.
    To remove a column from the list, select the column and click Remove.
  7. Click Next.
  8. Select Mark the Dimension Records with their Effective Date Range. Click Finish.
    The new mapping appears in the workspace. Make the necessary edits to the mappings.
    In the Type 2 Dimension/Effective Date Range mapping, the Designer uses three instances of the same target definition to enable the three separate data flows to write to the same target table. Generate only one target table in the target database.

0 COMMENTS

We’d like to hear from you!