Surrogate key limit

ray.wurlod · Post by **ray.wurlod** » Thu Mar 22, 2012 3:11 pm

The largest uint64 (unsigned BigInt) value is 18,446,744,073,709,551,615 which contains 20 digits.

Therefore your expression should allow for up to 20 characters.

Code: Select all

Right(Str("0",20) : InLink.SKey, 20)

srds2 · Post by **srds2** » Thu Mar 22, 2012 5:03 pm

Thanks Ray for the information. I will implement this logic in my job and check the result.

Thanks.

qt_ky · Post by **qt_ky** » Thu Mar 22, 2012 7:34 pm

uint64 (unsigned BigInt) = 64 bits or 8 bytes... not to be confused with the number of digits or characters in a string.

uint32 (unsigned Integer) = 4 bytes and up to 10 digits, so I'm not sure how you hit a limit of 9 digits. Double check your data types and functions used to generate the SKey.