Not able to generate a 4 digit surrogate Key
Posted: Thu Apr 26, 2007 12:40 am
Hi all,
I am facing a problem generating 14 digit surrogate keys. using surrogate key gen. I guess it supports max 10 digit keys.
I know that i can use row generator to generate sequence of numbers.
But row generator works in sequential mode.
Even transformer can be used in sequential mode. Can i use transformer in parallel mode and still generate keys for each natural key(ascending order)?
Is there any alternative that i can use to generate 14 digit keys without compromising on performance.
I am facing a problem generating 14 digit surrogate keys. using surrogate key gen. I guess it supports max 10 digit keys.
I know that i can use row generator to generate sequence of numbers.
But row generator works in sequential mode.
Even transformer can be used in sequential mode. Can i use transformer in parallel mode and still generate keys for each natural key(ascending order)?
Is there any alternative that i can use to generate 14 digit keys without compromising on performance.