In this post I will explain the job design to generate sequence numbers in Column Generator stage.
Sample job design would be like below:
open the column generator stage properties by double clicking on the stage.
Go to “Options”.
In “Column To Generate” property we need to give output column name that holds the sequence numbers.
Column To Generate=
For instance, I have given like below.
Column To Generate=Sequence
Also read: Datastage interview questions
Click on “Output” tab and you can see the column name that we just given above. Change the data type to Integer.
Click on “1”, then you see an Edit column metadata box
In properties put like
Type=Cycle
Increment=1
Run the job:
You can check the output, that would be:
Also read: Data warehouse interview questions
