Developer Transformation Guide > Sequence Generator Transformation > Creating a Sequence Generator Transformation

Creating a Sequence Generator Transformation

To use a Sequence Generator transformation in a mapping, add it to the mapping, configure the transformation properties, and then connect NEXTVAL to one or more transformations.

1. 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.

This screenshot shows the dialog box that appears when you want to create a Sequence Generator transformation. It includes the transformation name and location. The location is the path to the mapping where you want to create your transformation. Underneath the location, you have 2 choices; you can either select to create a new sequence or to choose an existing Sequence object. The second choice includes the option to browse for the Sequence data object or to create a new Sequence data object.

2. Enter a name for the Sequence Generator transformation.

The naming convention for Sequence Generator transformations is SEQ_<transformation name>.

3. Choose to create a new sequence or to use an existing Sequence object.

- To create a new sequence, select Create a new sequence. Click Next to configure the sequence properties. The following image shows the properties that you can configure:

This screenshot shows the Sequence properties that you can configure: Start Value, End Value, Increment Value, and an option for Cycle. The default Start Value is 0. The default End Value is 9,223,372,036,854,775,807. The default Increment Value is 1.

- To use an existing Sequence object, select Choose an existing Sequence object. Navigate to the Sequence 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.