I have a lot of sensitive data in production like SSN, name, email, and phone number.
I have function to scramble this data using a random value hashmap technique. But in the case of SSN (social security number), we have different tables that contain the same SSN. This causes my data to be messed up because I need to keep keep the same scrambled value for every instance of the same SSN.
Currently, if I have a SSN 12345678 in both the
person table and the
elige table, then my function's logic causes the tables to have different SSN values after scrambling (i.e. 854612397 for
person, 963258741 for
Desired output should be that the scrambled SSN is the same in both tables.