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:
Double-click the title bar of the Expression transformation, EXP_KeyProcessing_InsertNew.
Click the Ports tab.
Click in the far right corner of the Expression field of the PM_PRIMARYKEY port.
The Expression Editor appears.
Delete the existing value, 1000, and enter the value you want the Integration Service to use when incrementing the primary key. Click Validate.
