Table of Contents


  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
  17. Datatype Reference
  18. Configure the Web Browser

Customizing the Mapping

Customizing the Mapping

Depending on the number of versions you expect the dimension data to have, you might reduce or increase the increment the Integration Service creates between generated keys. By default, the Integration Service increments the sequence by 1,000. This allows for 1,000 versions of a single dimension.
If appropriate, you might reduce or increase the increment. To do this, you edit the Expression transformation, EXP_KeyProcessing_InsertNew, after creating the mapping.
To change the primary key increment:
  1. Double-click the title bar of the Expression transformation, EXP_KeyProcessing_InsertNew.
  2. Click the Ports tab.
  3. Click in the far right corner of the Expression field of the PM_PRIMARYKEY port.
    The Expression Editor appears.
  4. Delete the existing value, 1000, and enter the value you want the Integration Service to use when incrementing the primary key. Click Validate.

Updated June 25, 2018