Substitution Masking

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.

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.