Delphix Products

Expand all | Collapse all

How to update NULL data to specific data using masking algorithm?

  • 1.  How to update NULL data to specific data using masking algorithm?

    Posted 03-09-2019 07:11:00 PM
    Running masking job to mask something but there are some NULL records i would like to update those records also with some values then how can i update those NULLs with specific values ?

    #Masking


  • 2.  RE: How to update NULL data to specific data using masking algorithm?

    Posted 03-09-2019 07:37:00 PM
    Hi Rajesh, You can achieve your need by running an update of null columns with some values as pre-script of the masking job. Logically masking a null value which (means no signification nor a sensitive data in it) with a null value stay one of good secure ways of masking. Regards, Mouhssine


  • 3.  RE: How to update NULL data to specific data using masking algorithm?

    Posted 03-10-2019 11:35:00 PM
    Hi Rajesh,
    An alternate way is to create a secure lookup algorithm with an empty lookup file. That will convert everything to null.

    Thanks
    Hims