Delphix Products

 View Only
Back to discussions
Expand all | Collapse all

(data profiling) Profiler Results report - it is possible to have a flag for columns with UNIQUE index/constraint or FK ?

  • 1.  (data profiling) Profiler Results report - it is possible to have a flag for columns with UNIQUE index/constraint or FK ?

    Posted 03-05-2018 01:09:00 PM
    Dear Delphix Community,

    Masking of columns having:
    • UNIQUE constrain/index or
    • Foreign Key constrain
    requires special attention to use masking algorithm that is preserving uniqueness after masking, and preserving data integrity (relations to child tables for example) after masking.

    Please kindly advice, if there is (optional?) column in data profiler's report with flag for unique or FK constaint existing on column please ?

    thanks and regards,

    Adam Przybyslawski
    #Masking


  • 2.  RE: (data profiling) Profiler Results report - it is possible to have a flag for columns with UNIQUE index/constraint or FK ?
    Best Answer

    Posted 03-05-2018 01:21:00 PM
    Hi Adam,

    Please find the answer here 

    https://docs.delphix.com/docs-old/delphix-masking/masking-engine-user-guide/understand-and-manage-th...

    If a column is a primary key (PK), Foreign Key (FK), or index (IDX), an icon indicating this will appear to the left of the column name

    Regards,

    Mouhssine