Informatica Powercenter Express - Sequence Generator Transformation

Sequence Generator transformation is a passive transformation used to create unique primary key values, replace missing primary keys, or cycle through a sequential range of numbers. 

 * You can use a range of values from 0 to 9,223,372,036,854,775,807 with the smallest interval f 1.

Sequence Generator Ports

Pass-Through Ports

Pass-through ports are input and output ports that receive input data and return the same data to a mapping without changing it. We must add at least one input port to the transformation and connect it to an upstream source or transformation before you link the NEXTVAL output port to targets.

NEXTVAL Port

Connect the NEXTVAL port to a downstream transformation or target to generate a sequence of numbers. If you connect NEXTVAL to multiple transformations, the Integration Service generates the same sequence of numbers for each transformation. You connect the NEXTVAL port to generate the sequence based on the Start Value and Increment Value properties. If the Sequence Generator is not configured to cycle through the sequence, the NEXTVAL port generates sequence numbers up to the configured end value.

Sequence Generator Transformation Properties

Reset If enabled, the Integration service resets the sequence data object to the start value when the mapping run completes. If disabled, the Integration Service increments the current value after the mapping run completes, and uses that value in the next mapping run.

Tracing Level Level of detail about the transformation that the Integration Service writes into the mapping log.

*In case of any questions, feel free to leave comments on this page and I would get back as soon as I can.