Delphix Products

What are some algorithms to use to MASK $$$ dollar amounts such as salary, expenses, loans, bonus? Are there out-of-the box algorithms? Thanks
#Masking

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.

Can Secure Shuffle work to mix up the numbers?  or can SSN / SSN work to mix up numbers?  Thanks

For Secure lookup---I think you need to provide a Lookup text file--with value pairs--but the Salary numbers are too random to make a table of possible values.

Hi , The best one for salary, bonus, age ... is the max-min algorithm Regards, Mouhssine

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.

I see--that 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!

Correct, you can create as many secure lookups as you need with data that is realistic for your particular use cases.

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.