The Column Map lookup functions allow you to select values from a lookup table that are used to populate the destination table. Use the Lookup and Hash Lookup functions to select values based on the source value. Alternatively, the Random Lookup function allows you to select values from a lookup table without regard to the source value.
Optim™ supplies an Extract file, PRIVACY.XF, that you can use to create lookup tables. PRIVACY.XF includes names for Australia, Canada, Germany, Spain, France, Italy, and the US:
Each table has an integer key column that can be used with the Hash Lookup function.
See the Installation and Configuration Guide for more information.