Enforcing referential integrity
Figure 36: Configuring repeating to preserve referential integrity
How repeating works? It uses key properties (CustomerID) to identify the record. First time when record with certain value is being processed, random value from the list is selected and also recorded to a cross reference table (RepeaterID = “firstname repeating”). Each time when record with the same original CustomerID value is being processed, the value from the cross reference table is used.
Option: Repeating can be saved for future use, i.e. one can load previously saved repeating tables to achieve predictable masking results when rules are executed repeatedly.