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

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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
Photo of Adam

Adam

  • 140 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,732 Points 4k badge 2x thumb
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