Database Reference
In-Depth Information
The Sequence Generator transformation
Sequence Generator transformation is used to generate a sequence of unique numbers.
Unique values are generated based on the property defined in the Sequence Generator
transformation. A sample mapping showing the Sequence Generator transformation is
shown in the following screenshot:
As you can see in the mapping, the Sequence Generator transformation does not have any
input port. You need to define the start value, increment by value, and end value in the
properties. Based on properties, the sequence generator generates the value. In the preced-
ing mapping, as soon as the first record enters the target from the Source Qualifier trans-
formation,
NEXTVAL
generates its first value, and so on for other records. The sequence
generator is built to generate numbers.
