Hi,
Under each segment there minimum value that can be treated for masking is 2.
We are looking for Digit by Digit or Character by character by character masking. Hence Segment mapping will not work.
Please see below example and please suggest how we can achieve it. (Please Note: There can be digits and character of data length range from 10 to 20 )
Nine digit value masked value should get masked as below. (Mapping of number at the last of this mail)
Scenario 1: Below masked value is based on Green table below as a fixed values to be replaced.
| Database value | 1 | 3 | 5 | 2 | 2 | 4 | 9 | 4 | 0 |
| Masked value should | 9 | 4 | 1 | 8 | 8 | 5 | 6 | 5 | 7 |
Scenario 2:
| Database value | 1 | 3 | 5 | - | 2 | 2 | 4 | - | 9 | 4 | 0 |
| Masked value should | 9 | 4 | 1 | - | 8 | 8 | 5 | - | 6 | 5 | 7 |
If we use segment mapping , I will have only 9 segments with min 2 / 3/ 4 length. So it cannot be used here.
If we use character mapping then how we can add mapping per digit as per last table in this mail?
How we can do the masking for this using existing Delphix default rule?
Fixed Mapping of fixed numbers for 0-9
| Number | Always mapped to |
| 1 | 9 |
| 2 | 8 |
| 3 | 4 |
| 4 | 5 |
| 5 | 1 |
| 6 | 2 |
| 7 | 3 |
| 8 | 4 |
| 9 | 6 |
| 0 | 7 |
| - | - |
Regards,
Nandkumar Patel
This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.