Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 09 May 2001 @ 13:37:08 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Unique Row ID
From:   Eric J. Kohut

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.

Good Luck,


Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020