Data masking functions

Data masking functions provide various methods to transform or mask sensitive data.

Lookup Functions
Use the lookup functions to select values from a lookup table that are used to populate the target table. Use the Lookup and Hash Lookup functions to select values based on the source value. Alternatively, use the Random Lookup function 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.
TRANS SSN Function
Use the TRANS SSN function to generate a valid and unique U.S. Social Security Number (SSN). By default, TRANS SSN algorithmically generates a consistently altered destination SSN based on the source SSN. TRANS SSN can also generate a random SSN when the source data does not have an SSN value or when there is no need for transforming the source SSN in a consistent manner.
TRANS CCN Function
Use the TRANS CCN function to generate a valid and unique credit card number (CCN). By default, TRANS CCN algorithmically generates a consistently altered CCN based on the source CCN. TRANS CCN can also generate a random value when the source data does not have a CCN value or when there is no need for transforming the source CCN in a consistent manner.
TRANS EML Function
Use the TRANS EML function to generate an email address. An email address consists of two parts, a user name followed by a domain name, separated by ‘@'. For example, user@domain.com.
TRANS COL Function
The TRANS COL function can mask data that has no inherent format or a format that is not widely known. TRANS COL maintains the format and character type of the source data at the destination.
TRANS NID
Use the TRANS NID function to mask national ID numbers.
Substring Function
The Substring Function returns a substring of the contents of the named column.
Random Function
The Random Function returns a number selected at random within the range indicated by the low and high values.
Sequential Function
The Sequential Function returns a number that is incremented sequentially. The syntax is:
Identity or Serial Function
The Identity and Serial Functions direct the DBMS to supply a sequential value (integer) for a destination column. The syntax for these functions is:
Oracle Sequence Function
The Oracle Sequence Function assigns a value to the destination column by using an Oracle Sequence.
Propagate Primary or Foreign Key Value Function
The Propagate Function assigns a value to a primary key or foreign key column and propagates that value to all related tables.
Concatenated expressions
Concatenation allows you to combine column values or combine a column value with another value, by using a concatenation operator (CONCAT, ||, or +). A concatenated expression can include character values or binary values, but not both:
Numeric expressions
Use a numeric expression to specify a value in the source column whenever the data types for the corresponding source and destination columns are compatible.
Literal and value functions
Use the literal and value functions to specify literals such as a string or hexadecimal and values such as NULL or a special register.
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:
Auto-Generated Email Name
The auto-generated email name function generates an email address with a user name based on a literal concatenated with a sequential number. The sequential numbers are suffixes that begin with 1 and are incremented by 1. The function uses the domain name from an email address in a specified source column.
Formatted Email Name
The formatted email name function generates an email address with a user name based on values obtained from one or two attributes. The policy uses the domain name from an email address in a specified source column.
Random Number Function
The random number function generates numbers selected at random within the range indicated by the low and high values.
Sequential Number Function
The sequential number function generates numbers that are incremented sequentially.

Parent topic: Masking data