Test Data Manager

 View Only
  • 1.  And/Or condition in WHERE Clause for File Masking(FDM)

    Posted Jul 15, 2019 06:38 PM
      |   view attached
    Hi All,

    I have a requirement to mask a Name Field with commercial/personal name depending on account type filed. So If Account Type Field is PDA/SAV,
    Name Field should have personal name and if Account Type is CDA then name field should have commercial name in it. How can I achieve this for File Masking as I see no option to add multiple Tabs like we do for Distributed(Oracle/SQL) Databases where I can give condition for Personal Accounts on one tab while for commercial on other tab. I have attached screenshot of conditions


  • 2.  RE: And/Or condition in WHERE Clause for File Masking(FDM)
    Best Answer

    Broadcom Employee
    Posted Jul 22, 2019 02:00 PM
    Are you able to right-mouse on the "File Mask" tab to create a 2nd tab where you can set the other WHERE condition?



  • 3.  RE: And/Or condition in WHERE Clause for File Masking(FDM)

    Posted Jul 22, 2019 09:39 PM
    Yes. Thanks for helping me figure this out.