Archives of the TeradataForum
Message Posted: Thu, 18 Jan 2001 @ 13:34:52 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|