The Add sequence step adds a sequence to the stream. A sequence is an ever-changing integer value with a specific start and increment value. You can either use a database sequence to determine the value of the sequence, or have it generated by Kettle.
Name of the step; this name has to be unique in a single transformation.
Name of the new sequence value that is added to the stream
Enable if you want the sequence to be driven by a database sequence.
Connection name: choose the name of the connection on which the database sequence resides
Schema name: specify the table's schema name (optional)
Sequence name: allows you to enter the name of the database sequence
Use counter to calculate sequence: Enable if you want the sequence to be generated by Kettle
Counter name (optional): if multiple steps in a transformation generate the same value name, this option allows you to specify the name of the counter to which you want to associate with. Counter name avoids forcing unique sequencing across multiple steps.
Start at: give the start value of the sequence.
Increment by: give the increment of the sequence.
Maximum value: maximum value after which the sequence return to the start value (Start At).