difference between key_generation,gen_row_num

dataservices job design
1

Hi,

please tell me whats the difference between key_genaration transformation and gen_row_num() funtion.it seems both are same then what is the difference between both.

thanking you,
regards,
Ramana.

Ramana :india: (BOB member since 2009-04-30)

2

gen_row_num() always starts with the value 0.
key_generation() does a select max(key) against the table to find the starting value. If there is none, it starts with 1.

Werner Daehn :de: (BOB member since 2004-12-17)