How to create a Secure Lookup algorithm with our own listed values in a specific column?

  • 1
  • 1
  • Question
  • Updated 2 months ago
  • Answered
How to create a Secure Lookup algorithm with our own listed values in a specific column, For example, a custom Email Secure Lookup algorithm with a list of email addresses that we create.
Photo of Rajesh Dadi

Rajesh Dadi

  • 402 Points 250 badge 2x thumb

Posted 2 months ago

  • 1
  • 1
Photo of Hims

Hims, Employee

  • 2,592 Points 2k badge 2x thumb
Official Response
Hi Rajesh,
You can create a list of values by extracting the unique values from the column into a file and then use it as a lookup file for creating the algorithm. Please ensure the file's character-set is compatible with your target database.  Preferably no nulls and special/non-printable characters.
For more details refer here - https://maskingdocs.delphix.com/Securing_Sensitive_Data/Configuring_Your_Own_Algorithms/

Thanks
Hims