Generate Sequence Component

Generate Sequence Component



Generate Sequence Component

The Generate Sequence component generates a sequence of rows from a starting value to an end value with a user-defined increment.

This component can be used to generate empty rows of data from nothing, for use in a job.


Properties

The table below cites the Generate Sequence component's setup properties, including any actions required of the user.

Property Setting Description
Name String Input the descriptive name for the component.
Starting Value Integer The sequence value of the first generated row.
Increment Value Integer The number to increment the sequence by on each iteration.
End Value Integer The maximum value of the sequence. This does not need to be part of the sequence.
Output Column String Specify the name of the output column that contains the sequence value.

Strategy

Uses a SELECT statement with a window function over a dummy query to generate rows from scratch.
Uses a SELECT statement with a window function over a dummy query to generate rows from scratch.


Example

This job creates a sequence that outputs a list of years from 1990 to 1999.

The properties are set up as below (note how the End Value is not part of the sequence):

The sequence generates the following output: