What are some algorithms to use to MASK $$$ dollar amounts such as salary, expenses, loans, bonus? Are there outofthe box algorithms? Thanks
 100 Points
Posted 2 weeks ago
John Leser, Employee
 300 Points
One option that might meet your needs is to construct a Secure Lookup algorithm with reasonable dollar amount replacement values. I've found that so long as all the lookup values are valid numerical amounts such as "125.50", etc. the SL algorithm will work to mask numerical data.
If you're hoping to preserve more of nature of your data, another option is using min/max algorithm to eliminate outliers that might identify a specific individual.
If you're hoping to preserve more of nature of your data, another option is using min/max algorithm to eliminate outliers that might identify a specific individual.
 100 Points
Can Secure Shuffle work to mix up the numbers? or can SSN / SSN work to mix up numbers? Thanks
 100 Points
For Secure lookupI think you need to provide a Lookup text filewith value pairsbut the Salary numbers are too random to make a table of possible values.
 5,846 Points
Hi ,
The best one for salary, bonus, age ... is the maxmin algorithm
Regards,
Mouhssine
The best one for salary, bonus, age ... is the maxmin algorithm
Regards,
Mouhssine
John Leser, Employee
 300 Points
Official Response
For secure lookup, the file you provide is a newline separate list of replacements, like:
100.00
200.00
300.00
400.00
The masking behavior of secure lookup is to cryptographically hash each input value, and replace it with one of the values from the lookup file based on the hash result. So the result with my example input file would be each value replaced with one of those 4 values. There is no need to provide any information about the potential input values.
100.00
200.00
300.00
400.00
The masking behavior of secure lookup is to cryptographically hash each input value, and replace it with one of the values from the lookup file based on the hash result. So the result with my example input file would be each value replaced with one of those 4 values. There is no need to provide any information about the potential input values.
(Edited)
 100 Points
I seethat is quite simple then!! Sounds good. So I can make multiple Algorithms for Salary, Bonus, hourly rate, etc with associated Unique lookup tables so the substituted New Values (as masked values) are valid for the ranges and field criteria like 401K =Y/N. THANKS!
John Leser, Employee
 300 Points
Correct, you can create as many secure lookups as you need with data that is realistic for your particular use cases.
John Hanratty, Employee
 620 Points
I agree a SL algorithm would work well here. You might include a $ character in your SL file if needed. Even a Segmented Mapping would work. *note: keep in mind if the bonus amount needs to correspond in range of the salary amount.
Related Categories

General Information
 419 Conversations
 175 Followers

Delphix Masking
 221 Conversations
 71 Followers

Community How To
 15 Conversations
 9 Followers