The Sequence transformation is a passive and connected transformation that generates numeric values. Use the Sequence transformation to create unique primary key values, replace missing primary keys, or cycle through a sequential range of numbers.
The Sequence transformation contains pass-through fields and two output fields, NEXTVAL and CURRVAL.
The
mapping
task generates a numeric sequence of values each time the mapped fields enter a connected transformation. You set the range of numbers in the Mapping Designer. You can change the initial number in the sequence when you run the task.
After the task completes, you can see the current value and the initial value for a Sequence transformation in the
ASK INFAPreview
