Column Import stage: fast path (DataStage)

This section specifies the minimum steps to take to get a Column Import stage functioning.

About this task

IBM® DataStage® has many defaults which means that it can be very easy to include Column Import stages in a job.

1. Go to the Properties section on the Stage tab. Then, go to the Input section.
2. Specify the column that you are importing. In the Output section:
   1. Choose the Column method, this is Explicit by default, meaning you specify explicitly choose output columns as destinations. The alternative is to specify a schema file.
   2. If you are using the Explicit method, choose the output columns to carry your imported input column. Click Add key + to add more input columns.
   3. If you are using the Schema file method, specify the schema file that gives the output column details.
3. On the Output tab, in the Format section, specify the format of the column you are importing. This informs IBM DataStage about data format and enables it to divide a single column into multiple columns.
4. On the Output tab, click Edit in the Columns section. and in the Maps from input column section check that the input columns are mapping onto the output columns as you expect. The mapping is carried out according to what you specified in the Properties section on the Stage tab.