Hi Manoj,
Thanks for reaching out. Hope all is well.
The non-conforming warnings are for values that are not masked due to the data is not matching the defined rules for the algorithm(s) used. In this case '
BH_Telephone_SM_test' algorithm, which is a
Segment Mapping (SM).
The Segment Mapping algorithm is only taking A-Z and 0-9 (US Letters and Numbers) and the characters classification are assigned according to and in the following order:
- Letters (L)
- Numbers (N)
- Marks (M)
- Separators (Z)
- Punctuation (P)
- Symbols (S)
- Other (O)
Note: that there might be Numbers (N) and Letters (L) that are not non-conforming as well (for example extended unicode numbers and letters).
For details about the Unicode characters please look here: https://www.compart.com/en/unicode/category/To find any non-conforming rows in the data I do recommend using the query below.Finding Spacial CharactersFor finding Special Characters, please change the details indicated:
-- Replace [table]
-- Replace [mask_col]
-- Modify 1001 if more sample data is needed.
SELECT [mask_col] FROM [table]
WHERE ROWNUM < 1001
AND regexp_like([mask_col],'[^a-zA-Z0-9]');
When found, please add these special characters in the Ignore Characters in the SM algorithm.
Kind regards,
Anders
------------------------------
Anders Karlsson
Delphix Support
Delphix
------------------------------
Original Message:
Sent: 11-05-2019 02:11:54 PM
From: Manoj Ravikumar
Subject: nonconforming data that was not masked by algorithm
Hi,
We see the following warnings during our masking process. Please assist.
Column Telephone1 contained nonconforming data that was not masked by algorithm BH_Telephone_SM_Test
The top nonconforming data samples were:
PNNNPZNNNNNNN
NNNZNNNNNNN
SNNNNNNNNNNNN
SNNNNNNNNNNN
SNZPNNNPZNNNPNNNN
SNZNNNPNNNPNNNN
SNNNNNNNNNNNNN
SNNNNNNNNN
SNZNNNZNNNZNNNN
NNNNNZNNNNNN
Column Telephone2 contained nonconforming data that was not masked by algorithm BH_Telephone_SM_Test
The top nonconforming data samples were:
NNNZNNNNNNN
NNNZNNNZNNNN
NNNZNNNPNNNN
PNNNPZNNNPNNNN
LLLLLLZLLLLLLLLL
NNNPZNNNPNNNN
NNNZNNNZNNNNZ
SNNZNNNNNNNNNN
SNNNNNNNNNNN
SNNNNNNNNNNNN
Column MobilePhone contained nonconforming data that was not masked by algorithm BH_Telephone_SM_Test
The top nonconforming data samples were:
NNNZNNNZNNNN
NNNZNNNNNNN
NNNPNNNZNNNN
PNNNPZNNNPNNNN
NNNZNNNPNNNN
NNNSNNNPNNNN
NNNPNNNSNNNN
NNNPZNNNPNNNN
SNNZNNNNNNNNNN
PNNNPNNNPNNNN
------------------------------
Manoj Ravikumar
IT Systems Engineer
Bright Horizons Family Solutions
------------------------------