Optim Data Privacy Providers
11.7.0
|
![]() |
Modules | |
Specific Parameters | |
Example | |
Service Identifier: LKP
NOTE : The current version of the Lookup service provider supports only Oracle, DB2-LUW v9.1 and beyond as well as DB2 z/OS v9.1 and beyond
Certain types of generic data like names, addresses, etc can not be generated using arithmetical logic. When there is a need to mask such data a similar set of replacement data is required. The process of looking up this replacement data using a key from source data is called lookup.
The primary requirement for doing lookup is to have a set of replacement data which is similar in type to the original data. So as a rule, a name is replaced by a name, an address is replaced by an address and so on. Replacement data is normally stored as a set of rows in a database with a key column. Value(s) in the key column(s) of original data or a Hash value generated from original data columns are used to lookup in the key column of lookup table to fetch a replacement record. Typically the replacement records are so selected that they are unrelated to the original records but contextually similar.
Lookup Service Provider provides lookup functionality with three types of key lookups:
Plain lookup :
Key source field(s) are used to find matching records in lookup data. There must be a 1-1 mapping between the source key data and replacement key data.
There are two forms of Plain Lookup :
The following Common Parameters apply to the Lookup Service Provider:
Data Types
The Lookup Service Provider supports the following data types for the source and destination column: