Repeatable Output

. Returns deterministic results between sessions. The Data Masking transformation stores masked values in the storage table.

Seed Value.

Apply a seed value to generate deterministic masked data for a column. Enter a number between 1 and 1,000.

When you disable unique output, the Data Masking transformation might not mask input values to unique output values. The dictionary might contain fewer rows.

Unique Port

. The port used to identify unique records for substitution masking. For example, you want to mask first names in a table called Customer. If you select the table column that contains the first names as the unique port, the data masking transformation replaces duplicate first names with the same masked value. If you select the Customer_ID column as the unique port, the data masking transformation replaces each first name with a unique value.

Dictionary Information

. Configure the reference table that contains the substitute data values. Click

Select Source

to select a reference table.

Lookup condition.

Configure a lookup condition to further qualify what dictionary row to use for substitution masking. The lookup condition is similar to the WHERE clause in an SQL query. When you configure a lookup condition you compare the value of a column in the source with a column in the dictionary.

For example, you want to mask the first name. The source data and the dictionary have a first name column and a gender column. You can add a condition that each female first name is replaced with a female name from the dictionary. The lookup condition compares gender in the source to gender in the dictionary.