Repeatable Output
Repeatable Data Masking output returns deterministic values. Use repeatable masking when you run a Data Masking task more than once and you need to return the same masked values each time it runs.
Configure repeatable output if you have the same value in multiple source tables and you want to return the masked value in all of the target tables. The tables in the target database receive consistent masked values.
For example, customer John Smith has two account numbers, 1234 and 5678, and the account numbers are in multiple tables. The Data Masking task always masks the name John Smith as Frank Martinez, the account number 1234 as 6549, and the account number 5678 as 3214 in all the tables.
You can enter a seed value when you configure repeatable output. You can configure a dictionary file with data values that you can replace when you use substitution masking. When you configure repeatable output, the Data Masking task returns the same value from the dictionary whenever a specific value appears in the source data.
Seed Value
Apply a seed value to create repeatable output for data masking output. The seed value is a starting point for generating masked values.
You can define a seed value from 1 through 999. The default seed value is 190. Apply the same seed value to a field to return the same masked data values in different source data. For example, if you have the same Cust_ID field in four tables and you want all of them to generate the output with the same masked values, apply the same seed value when you mask each field.
You cannot use a seed value for random and custom data masking rules.