A Sequence Generator PowerCenter - Transformations generates unique values, such as primary keys, for a target in a mapping. You can also use it to cycle through a closed set of values.
Many relational databases include sequences, which are special database objects that generate values. The Sequence Generator transformation functions like a sequence object in a database.
However, in PowerCenter, you do not need to write SQL code to create and use the sequence in a PowerCenter - Mapping.
The Sequence Generator transformation has the following properties:
The Sequence Generator transformation has two output ports, NEXTVAL and CURRVAL, which correspond to the two pseudo-columns in a sequence. When you query a value from the NEXTVAL port, the transformation generates a new value.
Note: You cannot add any new ports to this transformation or reconfigure NEXTVAL and CURRVAL.
The properties for the Sequence Generator transformation appear. You do not have to change any of these settings.
To know all about how to push the sequence transformation logic into a database, see the doc PC_861_AdvWorkflowGuide.pdf Chapter 4 Working with sequence and view