Column Generator stage: Stage tab
The Column Generator Stage tab enables you to control aspects of the Column Generator stage.
Double-click the stage to open the stage properties panel. The Properties section lets you specify what the stage does. The Advanced section allows you to specify how the stage executes. Specify an optional description of the stage.
Properties
| Category/Property | Values | Default | Mandatory? | Repeats? | Dependent of |
|---|---|---|---|---|---|
| Options/Column Method | Explicit/ Column Method | Explicit | Y | N | N/A |
| Options/Column to Generate | output column | N/A | Y | Y (if Column Method = Explicit) | N/A |
| Options/Schema File | pathname | N/A | N | Y (if Column Method = Schema File) | N/A |
Column method
Select Explicit if you are going to specify the column or columns you want the stage to generate data for. Select Schema File if you are supplying a schema file containing the column definitions.
Column to generate
When you have chosen a column method of Explicit, this property allows you to specify which output columns the stage is generating data for. Repeat the property to specify multiple columns. You can specify the properties for each column using the Parallel tab of the Edit Column Meta Dialog box (accessible from the shortcut menu on the columns grid of the output Columns tab). You can use the Column Selection dialog box to specify several columns at once if required.
Schema file
When you have chosen a column method of schema file, this property allows you to specify the column definitions in a schema file. You can browse for the schema file or specify a job parameter.
Advanced
This section allows you to specify the following:
- Execution Mode. The stage can execute in parallel mode or sequential mode. In parallel mode the input data is processed by the available nodes as specified in the Configuration file, and by any node constraints specified on the Advanced section. In Sequential mode the entire data set is processed by the conductor node.
- Combinability mode. This is Auto by default, which allows IBM® DataStage® to combine the operators that underlie parallel stages so that they run in the same process if it is sensible for this type of stage.
- Preserve partitioning. This is Set by default. You can explicitly select Set or Clear. Select Set to request the next stage should attempt to maintain the partitioning.