Hi Jennifer. In most circumstances yes, providing that the you are using the same masking engine and that you are assigning the same masking algorithm to both columns. There are caveats to this and boils down to knowing the masking algorithm (algo) you are using. To clarify further , for example:
- if you are using a Secure Lookup (SL) algo, for example John always get masked to Peter ( providing refential integrity) ,
but Peter might also be the masked value for Tom. This is because the SL algo does not guarantee uniqueness.
- if you are using a customised algorithm you need to ensure/test that the algorithm/logic you created results in referential integrity
- if your target data is a date, and you decide to use the Date Shift algo, then you would need to know that 1 of the 3 date-shift algorithms (Variable Date Shift) will not mask
to the same value
- the credit card algo does not provide referential integrity. We'd suggest using something like Mapping algo, Segmented mapping algo , customised algo
- the Mapping algorithm provides referential integrity
- Mapping results could also change if you change the encryption keys of a the masking engine. But in this case it will affect all new masking after the encryption keys were changed.
On support.delphix.com there are docs with info on the available algos (just enter on the search prompt: masking algorithm
and there is also an FAQ on masking algorithms
If you're unsure about anything and your query may be more urgent, please feel free to raise a support ticket. We endeavour to respond as quickly as possible.
------------------------------
Marisa Damaso
Member of Technical Staff
Delphix
------------------------------
Original Message:
Sent: 04-03-2020 09:49:56 AM
From: Jennifer Cui
Subject: Same Masking Logic to 2 separate vDBs
Hi,
New to the product and have a question regarding masking.
I would like to mask the following 2 tables (Table_Organization and Table_Company) the same way. However the columns within it are not named the same.
So i would like to know if Table_Organization.Organization_ID = 12345 is masked to 55555, will Table_Company.Company_No =12345 also be masked to 55555? Same logic needs to apply to the second column below.
Database1:Table_Organization
Organization_ID
Organization_Name
Database2:
Table_Company
Company_No
Name
Thanks!
------------------------------
Thanks,
Jennifer
------------------------------