Deterministic masking across multiple tables where the masked column is the relationship column

madhankumar

Deterministic masking across multiple tables without using primary key and where the column names are not the same. Example: Table 1 (Employee) has EmployeeID and SocialSecurityNumber. Table 2 (Order) has OrderID, EmployeeID and SSN. Can the Social Security Number fields in all 2 tables be masked to the same values so the records continue to match.

The masked SSN value should never be a real SSN.

TheMaskedData

Hey @madhankumar have you tried using a Sync Manager? You can use the same method mentioned here: Masking Primary and Foreign Keys - Advanced Operations with Data Masker for SQL Server - Redgate University (red-gate.com)

The values don't actually need to be PKs/FKs rather can be a distinct set of values across 2 tables with no PK/FK relationship between them