Delphix Products

 View Only
  • 1.  Algorithm for Bits datatypes

    Posted 07-29-2019 01:14:00 AM
    HI Team,

    Do we have any algorithm to mask bits datatype(0,1) columns. Can you please suggest if it is. If no algorithm in Delphix, Request you to suggest the work around to mask those columns-Thanks!

    Kind Regards,
    Rajesh

    ------------------------------
    Rajesh Dadi
    Software Engineer
    Deloitte
    ------------------------------


  • 2.  RE: Algorithm for Bits datatypes

    Posted 07-29-2019 02:22:00 AM
    Hi Rajesh,

    You don't mask that type of field.

    There are only 2 values, so masking 0 will always give 1, and masking 1 will give 0. So you always know what was original value. Other way if 0 was masked to 0 and/or 1 to 1, you didn't mask data. And you need to remember that Delphix preserve masking consistency, so all fields with the same algorithm and domain will have the the same change of 0 to 1 or 1 to 1 etc., and by that you just wasted compute power of your engine, and overall you didn't masked data effectively.

    You are unable to and shouldn't mask all columns in the table.
    You should mask only columns in which type of data allow for sufficient randomness, otherway it's not masked.

    If for some reason you are forced to mask it you should null all values, or if it's not possible then you should replays all values to one chosen value, but then some will be the same as before masking (so not masked).

    Regards
    Karol

    ------------------------------
    Karol Kobus
    Consultant
    Spica Solutions
    ------------------------------