Archives of the TeradataForum

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

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

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>>