Custom Substitution Masking
You can use custom dictionaries when you perform custom substitution masking.
Substitution masking replaces a column of data with similar but unrelated data. Use custom substitution masking to replace production data with realistic test data from a flat file dictionary that you create. For example, you can create a dictionary that contains male and female first names. Use the dictionary to perform substitution masking on a column that contains both male and female first names.
Create a connection to the flat file dictionary from the Configure | Connections view.
When you configure the masking technique, select the flat file dictionary connection and then select the required dictionary file. 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.
You can substitute data with repeatable or nonrepeatable values. When you choose repeatable values, the Data Masking Transformation 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.
Note: When you run the mapping, the dictionary file must be present in the <Secure Agent installation directory>\apps\Data_Integration_Server\data location.
Custom Substitution Parameters
The following table describes the parameters that you configure for custom substitution masking:
Parameter | Description |
|---|
Dictionary Connection | The connection to the directory where the custom dictionaries are present. You must create a flat file connection with the directory that points to the dictionary files. |
Dictionary File | The custom dictionary that you want to select. The dictionary file must be present for all the Secure Agents in a run time environment in the following location: <Secure Agent installation directory>\apps\Data_Integration_Server\data |
Dictionary Column | The output column from the custom dictionary. You can select a dictionary column if the flat file contains column headers. |
Repeatable | Returns the same masked value when you run a task multiple times or when you generate masked values for a field that is in multiple tables. |
Seed Value | A starting number to create repeatable output. Enter a number from 1 through 999. Default seed value is 190. |