Applying a data masking policy

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.

  1. 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.
  2. Select the PHONE_NUMBER column.
  3. Click Apply Policy.
    The Apply Policy window opens.
  4. 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.
  5. In the policy editor Column map expression field, enter SHUFFLE(RETRY=12).
  6. From the main menu, click File > Save 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.