masking columns in a table that must be masked together
I have a table that looks something like this:
ID, FirstName, LastName, Date, Amount
I need to mask the Names, but all "John Smiths" must have the same name after masking, and all "Jane Doe" names must be the same after masking.
I can use a substitution rule for the names, but I don't want a different name for each record. I need to do substitution for distinct names. I know how to do this with T-SQL, which rule do I use with Data Masker?