Hash Source Value Access Path

The hash source value access path is used when the source value is not contained within the translate table. Source values are used to calculate a hash value. Then the translate table row that corresponds with that hash value is returned as the replacement row. Multiple source values can be used to calculate the hash value.

The hash source value access path does not require labels to be defined for each hash field. When the hash source access path is selected within a translate rule action, data elements are selected for the access path. If multiple data elements are selected, they must be arranged in the required order.

Within the access path definition, there is an option to request that key access always be used. When this option is selected, all access to the translate table rows is by key, and the translate table is not pre-loaded. This option should only be used when the key of the translate table is a sequential number and the number of rows in the translate table is significantly larger than the number of records being disguised. A table can have only one primary key. Select key access only when the key of the translate table is a sequential number and every access is to read the translate table by key. The translate table will not be pre-loaded.

At execution time, the source values that were selected for hash values are used to calculate a hash value. The translate table row that corresponds with the calculated value is returned as the replacement row.

The hash source value access path can request key access as long as the key of the translate table is a sequential number. If the requested key is not found, translate will fail due to an invalid translate table and execution of the disguise job will be terminated. Hash access is repeatable as long as the translate table is not changed. It is not reversible, and values are not unique since multiple source values can hash to the same replacement row.

For information on how to use a hash source value access path in a rule, see Translation-Rule-Actions-Hash-Source-Value-Access-Path. For information on how to create a hash source value access path, see Create-Hash-Source-Value-Access-Path-Definition.