Can we use multiple algorithms on single column using Delphix masking tool?

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
Photo of Ashok Kumar

Ashok Kumar

  • 240 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 5,846 Points 5k badge 2x thumb

Hi Ashok,

You can apply different kind of masking algorithms on a column, but you have to have different set to do it.

Create rule_set_1 apply algorithm_1 and create ruke_set_2 apply algorithm_2, but this drive a new question for you what conditions that let you decide which algorithm to use.

May be you ca expose your need to try if there is better way to manage it.

Regards,

Mouhssine

Photo of John Hanratty

John Hanratty, Employee

  • 620 Points 500 badge 2x thumb
Official Response

Hello Ashok and Mouhssine:

         This can be done by editing the filter option, by table in your rule set. First determine your requirements and which algorithm(s) to be applied for each. Multiple rule sets may be required and may only include the tables required for this step. Now you can edit the rules set and the table to apply your filter.  Then update your inventory to apply to correct algorithm for the filtered result set and mask. 

Tip: Please specify column name with table name prefix like customer.cust_id <1000.

If you have other columns in the table to be masked make sure all rows are in the result set of your filtered rule sets.

Thanks Jack
(Edited)
Photo of Ashok Kumar

Ashok Kumar

  • 240 Points 100 badge 2x thumb

Thanks for your help.

I want to mask and replace some specific positions in row level data.


For Example,
ASHOAB27284 and I want to mask 5th&6th Characters and 8th Character replace with 0 i.e. ASHOXX20284.

If we create multiple rulesets to achieve this, In Delphix we can apply only one algorithm for one masking job.We can not apply two rulesets on one masking job.

For automation purpose we can not use 2 masking jobs for one database.

Kindly please help me to get this.

(Edited)
Photo of John Hanratty

John Hanratty, Employee

  • 620 Points 500 badge 2x thumb
Hello Ashok: Can you expand the masking on this field. 
We can use a Segmented Mapping Algorithm but the min usage is 2 segment and length of 2 for each. 
Can we mask another character here? We can still mask the AB and char 8 to 0.

 ASHOAB27284

Or

ASHOAB27284

   
Thanks Jack 

Photo of Ashok Kumar

Ashok Kumar

  • 240 Points 100 badge 2x thumb
Sorry i am not getting your point here.

We want to mask ONLY 5&6th characters and 8Character should be replace by 0.

Thanks,
Ashok kumar.
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 5,846 Points 5k badge 2x thumb

Hi Ashok,

Create a segment mapping algo like this

1/ 3 segments of 4 alphanumeric values each 
2/ On segment 2 :
for the 2 first field set min and  masked value to X or the range to X-X
for the 4 field set min and max value to 0 or the range to 0-0
3/ On the preserve section of the algorithm :
start position 1 length 4
start position 7 length 1
start position 9 length 3

Hope it's clear for you

Regards,

Mouhssine