Not able to generate a 4 digit surrogate Key

[bhargava129189]

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.

[ray.wurlod]

In version 7.5 and earlier the Surrogate Key Generator supports up to uint32 - that is, a 10-digit key. You can satisfy yourself that this is so by inspecting the stage type properties.

In version 8.0 there is support for uint64 in the Surrogate Key Generator stage.

Row Generator stage works in sequential mode by default, but can be set up to execute in parallel mode. Go to the Advanced tab on the Stage properties. Set the cycle initial value to "part" and the increment to "partcount".

[nick.bond]

If you just need to run this job once creating a 'one off' list of SKs then you could use a transformer in parallel with

Code: Select all

@PARTITIONNUM * 10000000000000 + @OUTROWNUM

I don't have EE here so the system variable may not be called @PARTITIONNUM but it's something similar.

[DSguru2B]

Refer here.