Search for Source Value Access Path
The search for source value access path is used when the source value is contained within the translate table. The first translate table row that matches the source value is returned as the replacement row. The access path defines which fields within the translate table will be used as search values. The disguise rule action maps the source of the search value to the search value defined in the access path. At execution time, the source values contained within the data elements or variables that were mapped to the access path labels are used to search the translate table values for the replacement row that matches the search values.
A replacement row is returned when the values in the source field match the values within the translate table data. The search may include multiple data elements, in which case they must all match. If the translate table contains multiple entries that match the source value, the same row will always be returned.
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 search value is the entire primary key of the translate table, 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. If labels are not mapped for all fields within the key or the translate table source does not have a key, the option to choose key access is disabled. At execution time, key access will fail if the entire key is not provided or the translate table is not keyed.
Search access is repeatable as long as the translate table is not changed. It is not reversible, and values are unique only if the search and replace field values are unique.
The search source value access path will fail if no entry in the translate table matches the search values. If the source value is not found in the translate table, the disguise failed action defined for the translate table will apply and will be executed for each field being replaced.
For information on how to use a search for source value access path in a rule, see Translation-Rule-Actions-Search-for-Source-Value-Access-Path. For information on how to create a search for source value access path, see Create-Search-for-Source-Value-Access-Path-Definition.