Sequence Generator Transformation Rules and Guidelines
Consider the following guidelines when you create a Sequence Generator transformation:
- •You cannot connect the Sequence Generator transformation to an upstream transformation.
- •The Sequence Generator transformation cannot be connected alone. At least one field from the other connected transformation must be used in the mapping. For example, if you connect a Sequence Generator transformation and a Source transformation to a Target transformation, you must map at least one field from the Source transformation to the target.
- •When you map the NEXTVAL and CURRVAL output fields, ensure that the data type of the mapped field is appropriate.
- •When you run the mapping in the Mapping Designer, the current value is not saved so each time you run the mapping, it begins with the initial value.
- •When you run the task in the Mapping Configuration task wizard, you can edit the current value to start the sequence with a specified value.