Available in both passive and connected configurations, the Sequence Generator transformation is responsible for the generation of primary keys or a sequence of numbers for calculations or processing. It has two output ports that can be connected to numerous transformations within a mapplet. These ports are:
NEXTVAL: This can be connected to multiple transformations for generating a unique value for each row or transformation.
CURRVAL: This port is connected when NEXTVAL is already connected to some other transformation within the mapplet.