The Column Generator stage in DataStage is used to add extra columns with false data. It is a debug stage. It can be utilized while performing unit testing.
|Options/Column Method||Explicit/ Column Method|
|Options/Column to Generate||output column|
Let us generate extra column as Unique id;
- Go to the properties of Column generator stage.
- Define the column name as “Unique_Id” in the column to generate property
- Now Go to Output > Columns tab, and you could see the column set in above step is there.
- Now click edit row on this column this window will appear and define the values as given below image
- Close the properties
- Compile and run the job