Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 18 Jan 2001 @ 13:34:52 GMT


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


Subj:   Unique Value Algorithm
 
From:   Claybourne Barrineau

We built a datamart every week-end for all of our historical data for various company divisions. During the week, we update this table nightly with new data. On the following week-end, we delete everything and start the process over again.

I'm looking for an easy way take 3 integer values and convert them into 1 unique value (preferably an integer.) This 'first set' of values does not need to be reconstructable after the day that it is built; however, no values for the following 6 days can have the same value as one of those in the 'first set' of values.

Does anyone have any experience with this sort of algorithm?


Thanks,

Claybourne Barrineau



     
  <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: 27 Dec 2016