Options
How can I get Consistency in Masking
Waltz
Posts: 2 New member
I'm masking a table that has a field with FULLNAME and I'm trying to use a SUBSTITUTION Rule. So John Brown will be masked to Henry Clay and Mary Jane will changed to Betty White. The challenge I have is that I need all instances to John Brown to change to the same value. How can that be achieved?
Tagged:
Answers
You can achieve what you're looking for by using a Sync Manager rule.
Please see our documentation on how to create a sync manager rule here https://documentation.red-gate.com/dms/data-masker-help/masking-rules/sync-manager-rules
(As it notes, you can use a sync manager rule to " mask unique combinations data consistently, i.e. every "Alan Smith" becomes "Anita Radcliffe" in all tables...")
The sync manager rule will work with a single table as well and you won't need to make a temporary table.
When you first convert the substitution rule to a sync manager, it will actually only apply to the one target table (you would need to edit the rule to add other targets in order to apply to multiple tables).