In this exercise you will a column map to a table map.
A table map is required for a convert service. Use the associated
column map to enable the convert service to perform the data masking
function defined in the column map.
To add a column map to a table map:
- Expand the Tutorial folder in the Directory Explorer, expand
the Table Maps node, and double-click the SAMPLE.TMAP
table map. The Table Map Editor opens.
- Select the Table map tab.
- In the Table Map area, select the
OPTIM_CUSTOMERS table.
- Click Add Column Map. The New Column Map window opens with a list of column
maps that contain the selected tables.
- Select the SAMPLE.CMAP column map. Click OK.
- From the main menu, click to save the table map.
You have added the SAMPLE.CMAP column map (and its associated
data masking function) to the SAMPLE.TMAP table map, which will enable
a convert service to transform data.