Page 1 of 1
SEQUENCE NUMBER GENERATION FUNCTION
Posted: Tue Nov 10, 2009 4:16 am
by babuselvan
We want to generate sequence for a set of records. What is the available function to generate a sequence number for a set of record in the datastage?
You Can Use Surrogate Key Generator
Posted: Tue Nov 10, 2009 4:22 am
by mgendy
You Can Use Surrogate Key Generator , either in sequential mode , or in parallel mode using round robin partitioning method
SEQUENCE NUMBER
Posted: Tue Nov 10, 2009 4:25 am
by babuselvan
Can we have that surrogate key genertor function in server job mode?
Re: SEQUENCE NUMBER
Posted: Tue Nov 10, 2009 4:42 am
by mgendy
babuselvan wrote:Can we have that surrogate key genertor function in server job mode?
no , you can't use this stage in server jobs
Posted: Tue Nov 10, 2009 5:18 am
by bkumar103
you can use KeyMgtGetNextValue function
Posted: Tue Nov 10, 2009 6:37 am
by chulett
Or the @INROWNUM / @OUTROWNUM system variables. Or sequence objects in your database. Or...