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.
Users with an Optim™ Data Privacy License can use the Configuration Program to create the data privacy data tables, which contain values for lookup data. For more information, see Data Privacy Data Tables.)
Each table has an integer key column that can be used with the Hash Lookup function.