Create and add a flat file or relational dictionary connection to the

masking

task. For flat file dictionaries, you must create a flat file connection with the directory that points to the dictionary files. Add the connection to the relational or flat file dictionary from the

Configure | Connections

view.

When you configure a

masking

task, you can use the flat file or relational dictionary connection to perform custom substitution masking.

You can substitute data with repeatable or nonrepeatable values. When you choose repeatable values, the

masking

task produces deterministic results for the same source data and seed value. You must configure a seed value to substitute data with deterministic results. You can substitute more than one column of data with masked values from the same dictionary row.

You can configure the custom substitution masking rule to replace the target column with unique masked values for every unique source column value. To configure unique substitution masking, you must create a storage connection for the storage tables. Storage tables contain the source to dictionary value mapping information required for unique substitution masking.

When you configure the custom substitution masking rule, select the dictionary type, the connection, and then select the required dictionary file or table. You can then select the required column from the dictionary. To support non-English characters, you can use different code pages from a flat file connection.

The flat file connection code page and the Secure Agent system code page must be compatible for the

masking

task to work.