Split Subrecord stage (DataStage)

The Split Subrecord stage separates an input subrecord field into a set of top-level vector columns.

The Split Subrecord stage can have a single input link and a single output link.

The stage creates one new vector column for each element of the original subrecord. That is, each top-level vector column that is created has the same number of elements as the subrecord from which it was created. The stage outputs columns of the same name and data type as those of the columns that comprise the subrecord.
Shows a subrecord of vector being converted into a set of top-level vector columns

The Make Subrecord stage performs the inverse operation (see , "Make Subrecord Stage.")

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 Split 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.