The Preserve Original Data masking format retains the original values in a column. It is useful in conditional masking when you want to preserve a subset of values in a column and mask the remaining values using some other masking formats.
See Also:Conditional Masking
- No inputs are required.
- Combinable: No
- Deterministic: Yes
- Reversible: Does not apply
- Uniqueness: If the original values are unique, they will remain unique after masking.
Assume that a table has a
SALARY column that you want to mask by using the
EMPLOYEE ID column in a condition. If the
EMPLOYEE ID values are less than 100, you want to keep them. If they are from 100 to 199, you want to use the fixed number 100000. Any
EMPLOYEE ID greater than or equal to 200, you want to use a random number between 30000 and 500000.
The masking logic for the
SALARY column might look like the following:
EMPLOYEE_ID < 100 PRESERVE ORIGINAL DATA EMPLOYEE_ID < 200 FIXED NUMBER 100000 EMPLOYEE_ID >= 200 RANDOM NUMBER [Start Value: 30000 End Value: 500000]