Tip of the Day: Adding a Secure Lookup Algorithm

  • 1
  • Announcement
  • Updated 10 months ago
  1. Click Add Algorithm at the top right of the Algorithm tab.
  2. Choose Secure Lookup Algorithm.
  3. The Create SL Rule pane appears.
  4. Enter a Rule Name. (This name must be unique.)
  5. Enter a Description.
  6. Specify a Lookup File.
    This file is a single list of values. It does not require a header. Make sure there are no spaces or returns at the end of the last line in the file.
    The following is sample file content:

    • Smallville 
    • Clarkville
    • FarmvilleTownville 
    • Cityname 
    • Citytown 
    • Towneaster
    Delphix Agile Data Masking supports lookup files saved in ASCII or UTF-8 format only. If the lookup file contains foreign alphabet characters, the file must be saved in UTF-8 format for Delphix Agile Data Masking to read the Unicode text correctly. 

  7. When you are finished, click Save.
  8. Before you can use the algorithm (specify it in a profiling or masking job), you must add it to a domain.
Photo of Delphix FAQs

Delphix FAQs, Official Rep

  • 3,980 Points 3k badge 2x thumb

Posted 4 years ago

  • 1
Photo of Kangkan Goswami

Kangkan Goswami

  • 60 Points
I have a table having around 30000+ rows. The COUNTY column I wanted to mask and using SL algo. I added a file with the data. If I look at the data, I have only few hundred rows of unique values. But when applied, the masking results NULL. Am I doing something wrong?
Photo of Jaclyn Schoof

Jaclyn Schoof, Community Manager

  • 5,092 Points 5k badge 2x thumb
separate question

Please reference the new conversation here: SL algo