With the TDM you can use the Substitution Masking using the dictionary . For achieving the consistent results the following conditions should be met :
a. Enable repeatability and use the Same 'Seed' value in the dictionary . Use the same rule for both the Tables or create two separate rules with same configuration.
b. Both the tables , the data type and the length of the columns should match.
c. Both the tables should have the exact same records :
i. Case sensitivity should match.
ii. Spaces will be treated as character , hence the spaces should match.
Jack Jones - 10 characters . In all the tables it should be same.
If the above conditions are met , we can expect a consistent result across multiple tables using TDM .
Tahnk you very much for your input.
This is pretty much what I gathered also from other discussions in the forum.
A few notes though, after a test I did:
- I used two tables that had totaly different names
- I tried to mask columns that contained last names using dictionary
- The columns had different names but same data type and length
- Tables had different number of lines
Masking worked and achieved consistend masking for the same last names. I run the process multiple times and got the same results.
No i wonder how this will work in a larger scale and if dictionaries are stable enough as a solution.