In this exercise, you will apply a data masking function
to a column in a column map. You can mask data such as national ID
numbers, credit card numbers, dates, numeric values, and personal
information.
To apply a data masking function.
- Expand the Tutorial folder in the Directory Explorer, expand
the Column Maps node, and double-click the
SAMPLE.CMAP column map. The Column Map Editor opens.
- Select the PHONE_NUMBER column.
- Click Apply Policy. The
Apply Policy window opens.
- Expand the Data Manipulation node
and select Shuffle Policy. Click OK. The policy name appears in the Source Column column
and the policy editor opens in the Column Map Editor.
- In the policy editor Column map expression field,
enter SHUFFLE(RETRY=12).
- From the main menu, click to save the column map.
You have applied the Shuffle Policy to the PHONE_NUMBER
column. The policy will mask data by replacing values in the column
with other values in the column. The policy will search up to twelve
times for a replacement value that does not match the source value.