You can configure key masking for strings to generate repeatable output. Configure a mask format to define limitations for each character in the output string, define a mask format. Configure source string characters and result string replacement characters that define the source characters to mask and the characters to mask them with.
The following figure shows key masking properties for a string datatype:
You can configure the following masking rules for key masking string values:
Apply a seed value to generate deterministic masked data for a column. Select one of the following options:
Accept the default seed value or enter a number between 1 and 1,000.
. Use a mapping parameter to define the seed value. The Designer displays a list of the mapping parameters that you create for the mapping. Choose the mapping parameter from the list to use as the seed value.
Define the type of character to substitute for each character in the input data. You can limit each character to an alphabetic, numeric, or alphanumeric character type.
Source String Characters.
Define the characters in the source string that you want to mask. For example, mask the number sign (#) character whenever it occurs in the input data. The Data Masking transformation masks all the input characters when Source String Characters is blank. The Data Masking transformation does not always return unique data if the number of source string characters is less than the number of result string characters.
Result String Characters.
Substitute the characters in the target string with the characters you define in Result String Characters. For example, enter the following characters to configure each mask to contain all uppercase alphabetic characters: