Substitution masking replaces a column of data with similar but unrelated data. Use substitution masking to replace production data with realistic test data. When you configure substitution masking, select the type of substitution masking based on the data.
The following table describes the substitution masking types that are available:
Name
Description
Substitution Name
Substitutes source data with data from a dictionary file of names.
Substitution Female Name
Substitutes source data with data from a dictionary file of female names.
Substitution Male Name
Substitutes source data with data from a dictionary file of male names.
Substitution Last Name
Substitutes source data with data from a dictionary file of last names.
Substitution Position
Substitutes source data with data from a dictionary file of job positions.
Substitution US ZIP Code
Substitutes source data with data from a dictionary file of U.S. ZIP codes.
Substitution Street
Substitutes source data with data from a dictionary file of street names.
Substitution City
Substitutes source data with data from a dictionary file of U.S. city names.
Substitution State
Substitutes source data with data from a dictionary file of U.S. state names
Substitution Country
Substitutes source data with data from a dictionary file of country names.
The Data Masking transformation performs a lookup on the dictionary file and replaces source data with data from the dictionary. You download the dictionary files when you download the Secure Agent. The dictionary files are stored in the following location:
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.