Add Sequence
Options
Option | Description |
---|---|
Transform name | The name of this transform as it appears in the pipeline workspace. This name must be unique within a single pipeline. |
Name of value | Name of the new sequence value that is added to the stream. |
Use DB to generate the sequence | Enable if you want the sequence to be driven by a database sequence, then set these parameters: Connection name, Schema name (optional), Sequence name. |
Connection name | The name of the connection on which the database sequence resides. |
Schema name (optional) | The table’s schema name. |
Sequence name | The name of the database sequence. |
Use a pipeline counter to generate the sequence | Enable if you want the sequence to be generated by Hop, then set these parameters: Counter name (optional), Start at, Increment by, Maximum value. |
Counter name (optional) | If multiple transforms in a pipeline generate the same value name, this option enables you to specify the name of the counter to associate with. Avoids forcing unique sequencing across multiple transforms. |
Start at | The value to begin the sequence with. |
Increment by | The amount by which the sequence increases or decreases. |
Maximum value | The value after which the sequence returns to the Start At value. |