When I am using FIXED function in Masker it passes NULL as string and not as NULL value.
Data Before Masking Data After Masking
I want to make email column as NULL after masking.
I have conferred with an SME on this and he confirmed a way to accomplish this.
Please review this function:
Masking Functions and Parameters
The FIXED function masks the column values with the fixed values provided in Parm1.
Applies to: Date, Character, and Numeric
Example: The column ACCOUNT_NUMBER is masked with the fixed value 11100022 and the column PERSON_TYPE_CODE is masked with the value CUST.
Note: If you want to set the value to NULL, enter the string <NULL>. If you want to maintain a space, enter the string <SPACE>. The following table shows the usage:
Retrieving data ...