HOW TO GENERATE SEQUENCE NUMBER USING COLUMN GENERATOR STAGE

HOW-TO-GENERATE-SEQUENCE-NUMBER-USING-COLUMN-GENERATOR-STAGE

In this post I will explain the job design to generate sequence numbers in Column Generator stage.
Sample job design would be like below:

final-design-to-generate-sequence

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

column-generator-stage-properties

Click on “Output” tab and you can see the column name that we just given above. Change the data type to Integer.output-tab-on-column-generator-stage

Click on “1”, then you see an Edit column metadata box

In properties put like

Type=Cycle

Increment=1Edit-column-metadata-box

Run the job:

final-job-design-for-column-generator-stage

You can check the output, that would be:output-with-sequence-numbers-2 output-with-sequence-numbers-1

Also read: Data warehouse interview questions

Comments

comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: