Creating HASH Values in UDbgreenspun.com : LUSENET : DBAzine : One Thread
I am currently involved in producing a Data Warehouse from our On-Line system.
In the On-Line system, the Claims data is Uniquely identified by 3 ALPHANUMERIC keys.
In the Data Warehouse, the Claims data will have 1 INTEGER Primary Key.
Instead of allowing the key to be auto-generated by the action of adding a record to the row (as can be done in Version 7.2), I would like to use the keys in the On-Line-System to calculate the key to be used in the Warehouse.
Using Oracle, I would have simply concatinated the On-Line keys and used the function GET_HASH_VALUE to obtain the key.
Could someone please let me know if this functionality exists in Version 7.2 or how I might achieve the desired result?
-- Clive Barnard (firstname.lastname@example.org), June 17, 2002