Transformation Guide

Back Next

Sequence Generator Advanced Properties

Configure advanced properties that the Integration Service uses to generate sequential values.

The following table lists the advanced properties that you can configure for a sequence data object and a new sequence:

Property	Description
Reset	If enabled, the Integration service resets the sequence data object to the start value when the mapping run completes. If disabled, the Integration Service increments the current value after the mapping run completes, and uses that value in the next mapping run. This property is disabled for reusable Sequence Generator transformations and for non-reusable Sequence Generator transformations that use a reusable sequence data object.
Tracing Level	Level of detail about the transformation that the Integration Service writes into the mapping log. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.
Maintain Row Order	Maintain the row order of the input data to the transformation. Select this option if the Integration Service should not perform any optimization that can change the row order. Default is false.

The following list describes the Sequence Generator advanced properties you can configure:

Reset: If enabled, the Integration Service generates values based on the original current value for each session. If disabled, the Integration Service updates the current value to reflect the last-generated value for the session plus one, and then uses the updated current value as the basis for the next session run.

This property is disabled for reusable Sequence Generator transformations.
Tracing Level: Level of detail about the transformation that the Integration Service writes into the session log.