Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 09 Jul 2002 @ 16:32:39 GMT


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


Subj:   Re: Uniform Distributions from RANDOM number function
 
From:   Maxwell, Donald

Before everyone begins to think I just want to start an argument here, I would like to clarify:

I suggested this as a "longshot" idea, and personally, I'd have a hard time justifying this approach in my own production environment (in other words - "a snowball's chance in hell" of actually making it to production).

But, I continue to disagree with the objections raised so far. The colliding uniqueness problem is solved by concatenating the unique batch row identifier (BYTE datatype ). Concatenation of BYTE datatypes is supported. For that matter, one could define a two-column UPI on ROWID, BatchROWID without concatenation.

More to the point, there is no need to "re-sequence" the uniqueness value or otherwise modify the surrogate to hold sequential or other "relationship" information. It is a "pure" surrogate, whose only requirement is that it is different than the next surrogate!

Donald



     
  <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: 15 Jun 2023