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

Handling Keys

Handling Keys

When you use the Flag Current option, the Integration Service generates a primary key value for each row written to the target, incrementing key values by one. An Expression transformation increments key values by 1,000 for new dimensions.
When updating an existing dimension, the Integration Service increments the existing primary key by 1.
For example, the following dimensions are current dimension data (current flags set to one). Their primary keys are multiples of 1,000. This indicates they are both the first version of a dimension:
PM_PRIMARYKEY
ITEM
STYLES
PM_CURRENT_FLAG
3000
Sandal
5
1
4000
Boot
25
1
When the Integration Service inserts updated versions of these dimensions into the target, it sets the current flag to 1. It also creates a new primary key for the updated row by incrementing key of the existing dimension by one. The Integration Service indicates the existing dimension is no longer current by resetting its current flag to 0:
PM_PRIMARYKEY
ITEM
STYLES
PM_CURRENT_FLAG
3000
Sandal
5
0
4000
Boot
25
0
3001
Sandal
12
1
4001
Boot
15
1


Updated July 02, 2020