Masking Algorithm for unique number generation

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
How can I generate 8 digit unique numbers on a database for a primary key which includes 150000 rows in that table via Segmented Mapping algorithm ?

For Example I can use Mapping algorithm for this masking job but I have to put 150000 rows and update it everytime when there are data changes..

Do you have any idea to use other algorihtms ?
Photo of Cihan

Cihan

  • 300 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Hims

Hims, Employee

  • 1,922 Points 1k badge 2x thumb
Official Response
Hi Cihan,
Segmented Mapping Algorithm is a patented technology which segments target values and then masks those segments. A Segment Mapping algorithm needs to be as wide as the largest (longest) values in target column. It will always generate 1:1 unique values and maintains numeric/Alphanumeric types ( Do not give and range/min-max) values.

Please note the algorithms do not add /delete rows and maintain NULLs and EMPTIES for refrential integrity.

For more info please refer:
https://docs.delphix.com/display/DOCS50/Managing+Algorithm+Settings

Thanks
--Hims