What are the challenges you face when working across database platforms? Take the survey

How to mask part of primary key and still be unique?

I have a table where the primary key consist of 2 fields; a birth date and a sosial security number SSN (5 digits int).
I want to keep the birth date, and susbstitue the SSN, but there is some additional  requirements:
  1. The combination of birth date and SSN must be unique (primary key)
  2. The third digit of SSN must be unchanged, because it indicates gender, odd digit for male
  3. The other 4 numbers of the SSN shall be substituted with random numbers.
I think i have to use substitution because i have to syncronize this change Table-To-Table with a Sync Manager

Is this possible with Data Masker and is there an alreday defined dataset that i can use when my SSN field is an integer?


Sign In or Register to comment.