Skip to main content
Delphix

Algorithm: dlpx-core:Phone Unique (KBA10748)

  1. Last updated
  2. Save as PDF
 

 

KBA

KBA#
10748

 

At a Glance

Description The algorithm dlpx-core:Phone Unique is an Out-of-the-Box algorithm built on the New Algorithm Framework. This KBA explores and provides an example of masked results. 
Versions Applicable Continuous Compliance Engine versions: From 6.0.7.0 and up to the current version.
Updates The algorithm was updated in these versions:
  • 10.0.0.0 - DLPX-84303. Changed Nonconforming Data to be reported as a warning. 
  • 9.0.0.0 - DLPX-84488. Fixed zero-width errors.
Framework Frameworks used: 
  • dlpx-core:Character Mapping.
Data Type These are the valid Data Types: 
  • Char, VarChar, nChar, nVarChar (and similar) - It also works (less common) on Numeric types (INT etc).
Encoding ASCII Numeric
Strength Very fast
More info For troubleshooting using the logs and Non-Conforming Data warnings:

Example

Below is an example of masked data.

Note

Notes:

  • The algorithm will mask all 7 last digits in a string.
  • Text anywhere will not change the 7 last digits.
  • NULL and empty strings will pass through.
  • A string with no digits (only text) will result in Nonconforming Data. 

 

+--------+-------------------------------+-------------------------------+
| length |                          orig |                          mask |
+--------+-------------------------------+-------------------------------+
|      1 |                             1 |                             5 |
|      2 |                            12 |                            61 |
|      3 |                           113 |                           938 |
|      4 |                          1114 |                          4577 |
|      5 |                         11115 |                         38097 |
|      6 |                        111116 |                        963274 |
|      7 |                       1111117 |                       5610261 |
|      8 |                      11111118 |                      19099866 |
|      9 |                     111111119 |                     114185842 |
|     10 |                    1111111110 |                    1117112283 |
|     20 |          11111111111111111120 |          11111111111110347289 |
+--------+-------------------------------+-------------------------------+
|      9 |                Test 111111119 |                Test 114185842 |
|      9 |           Test 111111119 Test |           Test 114185842 Test |
|  4 + 4 |      Test 1114 Test 1114 Test |      Test 1203 Test 0710 Test |
|  4 + 9 |           1114 Test 111111119 |           1114 Test 114185842 |
|  9 + 9 | Test 111111119 Test 111111119 | Test 111111119 Test 114185842 |
+--------+-------------------------------+-------------------------------+
|        |                        [NULL] |                        [NULL] | 
|        |                            [] |                            [] |
|        |                           [ ] |                           [ ] |
+--------+-------------------------------+-------------------------------+
|        |                           DNC |                           DNC | < Nonconforming data "LLL"
+--------+-------------------------------+-------------------------------+

Nonconforming Data

If the input has no digits to mask, the algorithm will report this with a Nonconforming Data warning.

Note

Note:

It may be acceptable to have Nonconforming Data (as seen above). Codes such as DNC (Do Not Call) are common in call center databases.

 

Message:

Column mask value did not conform to the expected format algorithm dlpx-core:Phone Unique: 
Cannot mask phone number, reason - the input does not contain any maskable digits.

The top nonconforming data samples were: 
 * LLL

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Date Release
Feb 22, 2024 20.0.0.0
Jan 25, 2024 19.0.0.0
Dec 20, 2023 | Jan 10, 2024 18.0.0.0 | 18.0.0.1
Nov 21, 2023 17.0.0.0
Oct 18, 2023 16.0.0.0
Sep 21, 2023 15.0.0.0
Aug 24, 2023 14.0.0.0
Jul 24, 2023 13.0.0.0
Jun 21, 2023 12.0.0.0
May 25, 2023 11.0.0.0
Apr 13, 2023 10.0.0.0 | 10.0.0.1
Mar 13, 2023 | Mar 20, 2023 9.0.0.0 | 9.0.0.1
Feb 13, 2023 8.0.0.0
Jan 12, 2023 7.0.0.0
Releases Prior to 2023
Major Release All Sub Releases
6.0

6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1, 6.0.11.0, 6.0.12.0, 6.0.12.1, 6.0.13.0, 6.0.13.1, 6.0.14.0, 6.0.15.0, 6.0.16.0, 6.0.17.0, 6.0.17.1, 6.0.17.2

 

 

Privacy Policy Terms of Use Legal About
© 2024 Delphix Corp