Which Algorithm will give the same result for SAME UPPERCASE and LOWERCASE names?

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • Answered
I have two name column in DB
pankaj and PANKAJ applying the first name doamin and first name SL algorithm but getting the different result for both names but it should have to mask the name with same value.

I think this is big issue in delphix not working properly it is buggy software
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb
Is anyone there to answer this ?please do needful we are block
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 1,618 Points 1k badge 2x thumb
Hi Pankaj,
Thanks for the endorsement.
You can use a prescript to make the values upper or lowercase before applying the SecureLookup algorithm, it is set as a part of the rule.
Let me know if you need more details.  In the meantime I'll check your comment about an algorithm that applies the pre-script, so that you don't have to.
Regards,
Gary
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb
How to do it could you please give us the step by step information  how we can do i t
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 678 Points 500 badge 2x thumb
Hi Pankaj,

The reason why it comes out to be 2 different names is because the way Secured lookup works is by calculating a value based on Input. Now since case also changes the calculated value, hence, you see 2 different names based on the case.

As Gary mentioned, if you could, do the conversion in prescript.

Alternate option is to reach out to your Delphix Customer Success lead, there may be a customized mapplet available to use for this scenario.

Regards,
Mayank
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 1,274 Points 1k badge 2x thumb
Hi Pankaj,
I gave you a solution here: https://community.delphix.com/delphix/topics/getting-wrong-value-for-the-same-name-using-secure-look...

But let me do some considerations:
IMO this is not a bug: this is ordinary behavior of the SL Algorithm. As Mayank wrote above, the algorithm makes an hash value of the input value and then gets an index of row of your text file in order to get the output value. If you make an hash algorithm of two same values but they differ in upper/lower case character only, you'll take two different hash values. If you want to change this ordinary behavior, you can transform the values in order to get all them in upper or lower case. As suggested by Gary, you can use a pre-script or, alternatively, you can transform the values when the masking engine makes the query (See my suggestion here https://community.delphix.com/delphix/topics/getting-wrong-value-for-the-same-name-using-secure-look...) .

Thank you for giving us a confrontation about this interesting questions.

Best Regards.
Gianpiero
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 678 Points 500 badge 2x thumb
Also, Pankaj  - some food for thought.

If you have strict considerations to maintain the case for names, then if you are using the default first name SL algorithm, it may very well happen that the case is changing after masking from the original value.

Now, if that is not a consideration for you, then the solution with pre-script or with a custom SQL will work like a charm, but if it is a consideration, then custom mapplet is the way to go.

Regards,
Mayank
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 1,618 Points 1k badge 2x thumb
Hi Pankaj,
Glad we sorted out the issues over Webex with custom SQL and added a post script to uppercase the column again. Appreciate there are a couple of usability issues with sizing of panes and the spurious extra email alert. I have raised these with Support.
Please keep the community appraised of your progress and any features that you find are great for you!
Regards,
Gary