- Sequence Generator
The SG transformation generates numeric values. We can use the SG to create unique primary key values, replace missing primary keys, or cycle through a sequential range of numbers.
NEXTVAL:
We can use the NEXTVAL port to generate sequence numbers by connecting it to downstream transformation or target.
CURRVAL:
CURRVAL is the NEXTVAL plus Increment By value. We typically only connect the CURRVAL port when the NEXTVAL port is already connected to a downstream transformation. When a row enters a transformation connected to the CURRVAL port, the IS passes the last created NEXTVAL value plus one.
