Data Privacy Functions

Data Privacy functions provide various methods to transform or mask sensitive data. They require an Optim™ Data Privacy License.

Lookup Functions
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.
Shuffle Function
The Shuffle Function replaces a source value with another value from the column that is then inserted in a destination column. The source row and the row that contains the replacement value will never be the same, but depending on your data, source and replacement values can be identical.
Data Privacy Transformation Library Functions
The data privacy transformation library functions allow you to mask personal data such as national ID numbers, credit card numbers, and email addresses. You can generate transformed data that is valid and unique.
Age Function
Use the Age Function to age values in a source column. The source column can contain character, numeric, date, or timestamp data. A CHAR or VARCHAR column has a maximum length of 256 bytes.
Currency Function
Use the Currency Function to convert a currency value in a source column from one currency to another. The source column must be defined as numeric, but not floating point. Two conversion methods are available:

Parent topic: Using the Column Map Editor