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 (clive.barnard@uk.royalsun.com), June 17, 2002