The EXTENDED_LOOKUP schema includes lookup tables that can be used with the Optim™ lookup policies. Lookup policies processed by the executor platform must include a connection to a database with this schema.
The EXTENDED_LOOKUP schema includes lookup tables for masking personal data such as addresses, names, national ID numbers, birth dates, etc. Each category of personal data is provided in several tables that include country-specific personal data. For example, a table includes American addresses and another table includes German addresses.
The optim\designer\sampledata directory, located in the Infosphere Data Architect installation directory, includes .ddl and .data files that allow you to create the tables in the EXTENDED_LOOKUP schema. Create these tables using the interactive tool provided by your database vendor.
The optim\designer\sampledata directory includes the following subdirectories:
Each category of personal data is provided in a separate table for the following countries (abbreviations are in parentheses): Australia (AU), Canada (CA), France (FR), Germany (DE), Italy (IT), Japan (JP), Spain (ES), United Kingdom (UK), and United States (US). Each table includes a column of sequential numbers that is used with lookup policies that use hash values to select a row in the lookup table.
In the schema, each table name is composed of a country abbreviation prefix and the category (countryabbreviation_category). For example, the address table for Canada is named CA_ADDRESSES and the address table for Germany is named DE_ADDRESSES.
The schema includes the following categories:
ADDRESSES - includes columns for street address, city, locality (e.g., state or province), and postal code.
FIRSTNAME - includes a column with male and female first names.
FIRSTNAME_F - includes a column with female first names.
FIRSTNAME_M - includes a column with male first names.
LASTNAME - includes a column with last names.
PERSON - includes columns for birth date, first name, last name, gender, phone number, national ID number, company name, and e-mail address.