Masking Algorithm for unique number generation

  • 0
  • 1
  • Question
  • Updated 9 months 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


  • 300 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Hims

Hims, Employee

  • 2,592 Points 2k 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: