Version 1.1.1
 —  Data Masking  —

Adding a WHERE Clause to a Table to be Masked

A subset of a table can be masked by adding SQL to the mapping definition.

In the following example, table ADDRESS will only have those rows where ADDRESS_2 = ‘Addyston’ masked.

To do this, leave the column field blank and enter WHERE as the function, Parm1 will be the SQL to use on the table. The other row or rows for the table will specify the specific masking to apply to the table.

graphics/GTSDM_img_27.jpg

Top of page