To use a Sequence data object to create a Sequence Generator transformation, create the Sequence data object, configure the object properties, and select the object in the Sequence Generator transformation dialog box.
In the mapping editor, scroll down in the mapping palette to locate the Sequence Generator transformation and drag it to the mapping.
The
New Transformations
wizard opens.
Click
New Sequence Data Object
.
The
New Data Object
wizard opens.
Enter a name for the Sequence data object.
The naming convention for Sequence data objects is SEQ_<data object name>.
Click
Next
to configure the Sequence data object properties.
If you create a Sequence Generator transformation from the object, the transformation will use the properties you enter for the data object. The following image shows the properties that you can configure:
After you configure the data object properties, you can create a Sequence Generator transformation using the Sequence data object. When you create the transformation, name the Sequence Generator transformation, and select
Choose an existing Sequence object
. Navigate to the data object and click
OK
.
The Sequence Generator transformation appears in the mapping editor with a NEXTVAL output-only port. You can connect the NEXTVAL port to a downstream transformation or target to generate a sequence of numbers.
ASK INFAPreview
