Promote Subrecord stage (DataStage)

The Promote Subrecord stage is a restructure stage. It can have a single input link and a single output link.

The Promote Subrecord stage promotes the columns of an input subrecord to top-level columns. The number of output columns equals the number of subrecord elements. The data types of the input subrecord columns determine those of the corresponding top-level columns.

Shows a schematic of four columns in a subrecord being promoted to four top-level columns

The stage can also promote the columns in vectors of subrecords.

Shows columns from a vector of subrecords promoted to top-level columns

The Combine Records stage performs the inverse operation.

The stage editor has three tabs:

Stage tab. This tab is always present and is used to specify general information about the stage.
Input. This tab is where you specify the details about the single input set from which you are selecting records.
Output. This tab is where you specify details about the processed data being output from the stage.

Input tab

Specify an optional description of the input link in the Description section. In the Partitions section, specify how incoming data is partitioned before being converted. In the Columns section, specify the column definitions of incoming data. In the Advanced section, you can change the default buffering settings for the input link.

Output tab

The Promote Subrecord stage can have only one output link.

Specify an optional description of the output link in the Description section. In the Partitions section, specify how output data is partitioned before being converted. In the Columns section, specify the column definitions of output data. In the Advanced section, you can change the default buffering settings for the output link.