Generate Sequence Component

Generate Sequence Component

Generates a sequence of rows from a starting value to an ending value with a user defined increment.

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

Properties

Property Setting Description
Name Text 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 Text The name of the output column that contains the sequence value.

Strategy

 

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

Example

This job creates a sequence that outputs the nine times table.

The properties are set up as below. Note: how the End Value is not part of the sequence.

The sequence generated the following output.

For a more real world example this job generates a date dimension (which is effectively a sequence of dates with year, month, quarter, week, day etc broken out).

Set up as follows.