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

Terje

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?

Eddie D

Hi Terje,

There is certainly a SSN Numbers dataset that you can make use of it.

Please take a look at this help document which maybe useful to you, in the scenario you have described.

Many Thanks
Eddie

TheMaskedData

@Terje you might need to use a Row-Internal Rule converted to a Sync Manager rule, then you can use SQL syntax to effectively have a replacement value clause of SUBSTRING(SSN, Parts 1 - x of SSN that you want to keep) + DMSPARAM1 where DMSPARAM1 is a randomly generated 4 digit number