Advanced Masking Rules
An advanced masking rule is a combination of masking techniques that mask multiple source columns or a target column based on values of more than one input column.
For example, you can create a full masked name by masking the first name and last name input columns. Define variable columns to contain the masked names. Add an output column that contains a result of an expression that combines the first name and last name variable columns.
Create the following types of columns in an advanced rule:
- Input
- The source column that you want to mask.
- Variable
- A column that contains intermediate values in a calculation. The variable column receives a value from an expression or a masking technique. You can configure multiple variable columns in order to combine multiple masking techniques.
- Output
- The target column that receives the masked value. The output column type contains a masking technique and masking parameters.
Creating an Advanced Masking Rule
Create an advanced masking rule to combine more than one masking technique or to mask multiple columns.
1. To access the Policies view, click Policies.
2. Click Actions > New > Masking Rule.
The Rule Wizard appears.
3. Enter a name and optional description for the rule.
4. Select the Advanced masking rule.
5. Click Next.
6. In the Input Columns section, click Add New.
The Add Column dialog box appears.
7. Enter the column properties, such as the name, datatype, precision, and scale. Select whether the column is mandatory to assign to a data source in all projects.
You cannot enter masking properties for input columns.
8. Click OK.
9. To enter more input columns, click Create Input Column in the New Masking Rule dialog box.
10. In the Variable Columns section, click Add New.
11. Enter an expression, a masking rule, or a dependent column for each variable column that you define. If you apply a masking rule, configure the input column to create the variable column from.
12. Click OK.
13. In the Output Columns section, click Add New.
14. Enter an expression, a masking rule, or a dependent column for the output column.
15. Click OK.