About this task
InfoSphere® DataStage® has many defaults which
means that it can be very easy to include Column Generator stages in a job.
This section specifies the minimum steps to take to get a Column Generator
stage functioning. InfoSphere DataStage provides a versatile user
interface, and there are many shortcuts to achieving a particular end, this
section describes the basic method, you will learn where the shortcuts are
when you get familiar with the product.
To use a Column
Generator stage:
- In the Stage page Properties Tab, specify the Column Method. This
is explicit by default, which means that you should specify the meta data
for the columns you want to generate on the Output Page Columns tab.
If you use the Explicit method, you also need to specify which of the output
link columns you are generating in the Column to Generate property. You can
repeat this property to specify multiple columns. If you use the Schema File
method, you should specify the schema file.
- Ensure you have specified the meta data for the columns
you want to add. If you have specified a Column Method of explicit, you should
do this on the Output Page Columns tab.
If you have specified a Column Method of Schema File, you should specify a
schema file.
- In the Output Page Mapping Tab, specify how the incoming columns
and generated columns map onto the output columns.