Delphix Products

  • 1.  Masking Algorithm for unique number generation

    Posted 10-31-2016 12:40:00 PM
    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 ?
    #Masking


  • 2.  RE: Masking Algorithm for unique number generation
    Best Answer

    Posted 10-31-2016 02:10:00 PM
    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


  • 3.  RE: Masking Algorithm for unique number generation

    Posted 10-31-2016 03:07:00 PM
    Hi Hims I actually know how to use it but I tested for the scenerio I explained in my question actually and I got error i can send it later but it was somethhing like can not insert duplicate values in the primary key in


  • 4.  RE: Masking Algorithm for unique number generation

    Posted 07-12-2018 09:56:00 AM
    Hello, 

    I am getting the same problem. Have you solved this somehow?

    Thank you, 
    Mary


  • 5.  RE: Masking Algorithm for unique number generation

    Posted 07-12-2018 12:49:00 PM
    Hi Mary,
    Your individual scenario may differ but as a thumb rule, use a Segmented Mapping Algorithm with segments wide enough for the Max width of the value inside that column. An SM algo should be used for any column with a Unique Index on it.
    e.g for a 10 digit value we may create an SM algo with 3 Alphanumeric Segments of width 3X3X4.
    The UQ constraints/Indices needs to be disabled during the period while masking job is running.