Assign an advanced masking rule to a column and map source input columns to the rule input and output ports. To perform expression cascade, you can add another table, select columns from the table, and map the input columns. An expression cascade joins the two tables to generate a combined masked output.
In the
Define | Data Masking
view, click the
Masking Rule
column for the column that requires an advanced rule.
Select the advanced rule from the list.
The
Advanced Rule Assignment
dialog box appears with the list of columns in the table.
To select columns from another table, click the
Add Associated Table
icon.
The
Add Associated Table
dialog box appears.
Select an associated table and click
OK
.
The table name appears with a list of column.
Select a source input column in the left panel and a rule input port in the right panel.
When you select a source input column, the rule ports with same data type become available for mapping.
Click the
Link
icon to create a mapping.
An arrow appears that links the source port to the rule port.
To create a mapping, you can also click
Show Simple
and map the ports.
If you need to remove the link, select the source input port and the rule input port. Click the
Unlink
icon.
The arrow between the ports disappears.
After you map the rule input ports, click
Next
.
Provide a join condition for the two source input tables to perform expression cascade.
Click
Next
.
Select a rule output port in the left panel and a source input column in the right panel.
Click the
Link
icon to create a mapping. To remove a mapping, click the