Delphix Products

Expand all | Collapse all

Help requested

Jump to Best Answer
  • 1.  Help requested

    Posted 07-07-2020 11:40:00 AM
    Need help on the following

    We have Primary Key that is user defined and when we are trying to mask this primary key, it is failing with different combination of algorithms

    Please advice for example:

    Personnel_id is a PK and is user defined; masking this is failing with the following error:
    Error desc

    KV Subrahmanyam
    Delphix Community Members

  • 2.  RE: Help requested

    Posted 07-08-2020 06:54:00 PM
    Hello KV Subrahmanyam,

    Please open a support case for this issue via the Delphix Support Portal at

    Thanky you,

    Janet Anderson
    Director, Americas Customer Support

  • 3.  RE: Help requested
    Best Answer

    Posted 07-10-2020 01:53:00 AM

    Procedure would be:
    1) drop PK/FK  (either using checkbox or using pre/post script)
    2) mask PK column and all FK columns in other tables using the same deterministic uniqueness preserving algorithm.
    3) recreate PK/FK

    Some details to be aware of:

    As you drop the PK the logic needs another logical key to identify the rows. On Oracle we would always advise to use ROWID.

    On MSSQL add a temporary column of type identity and set that name in logical key.

    Use SM or SM_UNI (algorithm must be deterministic and uniqueness preserving) - those algorithms do that BUT they guarantee the unique result but not the uniqueness during the process.
    Last not least the most important question: Does the PK contain sensitive information like Name, DOB,SSN ? If not - no need to mask ;)

    Tino Pironti
    Technical Services