Optim Data Privacy Providers  11.3.0
 All Data Structures Files Functions Variables Macros Groups Pages
Modules
Lookup
Collaboration diagram for Lookup:

Modules

 Specific Parameters
 
 Example
 

Detailed Description

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:



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: