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 social security 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: