Archives of the TeradataForum
Message Posted: Wed, 09 May 2001 @ 13:37:08 GMT
Claybourne is correct; However, I would just use columns separated by a comma and not concatenated together. The effect is the same without converting all of the columns to character first. As long as the columns values in total are Unique then the CSUM will create a unique key id. Be careful of using columns with nulls due to the unknown nature of the value.
Also, you can cast the original number 1 as 1 (decimal(18,0)) this might help you get past the integer limitation if that is close. While CSUM is a little resource intensive, it should be the fastest way of creating this unique key id. You shouldn't have much of a skew problem if the values in the column list are unique. Spool of course is always a problem on your entire largest table in the system. Make sure you have enough.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|