Test Data Manager

 View Only
  • 1.  Pre masking steps

    Posted Oct 23, 2020 01:25 PM
    Hello Team,

    I am going to mask Oracle DB using FDM which also includes primary keys (first name,middle name,last name, Phone). 
    Could you please suggest what all do I have disable before executing Oracle masking (Primary/Foreign Keys, Indexes etc.)

    Thanks,
    John


  • 2.  RE: Pre masking steps

    Posted Oct 23, 2020 02:43 PM
    1. ​you may disable all the triggers;
    2. If you are going to change the primary keys too, then you may have to disable them as well. However, I would not recommend disabling and de-identifying primary keys unless they are a 'must' phi/pii risks and there are no concerns of maintaining the referential integrity i.e. you may have the same field de-identified consistently throughout the same schema/DB/environment.