Delphix Products

Expand all | Collapse all

Using fixed result in Character Mapping

Jump to Best Answer
  • 1.  Using fixed result in Character Mapping

    Posted 06-11-2021 08:22:00 AM
    Hi everyone,

    Do you know if there's any chance to use Fixed Result in Character Mapping algorithm? For example I have a column with Fax numbers and I want to change all numbers in this column to a fixed value like "999999".

    I know that it is possible this with Secure Lookup and also Segmented Mapping but I wonder if it would be possible to mask using Character Mapping.



    ------------------------------
    Rahim Cetinel
    Lead DataOps Architect | Delphix Blackbelt
    ------------------------------


  • 2.  RE: Using fixed result in Character Mapping
    Best Answer

    Posted 06-11-2021 09:11:00 AM

    Hi Rahim,

    I haven't personally tried with Character Mapping but another way to do that would be by using a Custom SQL and assign a fixed value to the column to mask.
    You can refer to this KB article here: https://support.delphix.com/Delphix_Masking_Engine/Using_Custom_SQL_(KBA1764), under section "Set the masked value or string to a constant".

    Regards

    Sandro



    ------------------------------
    Sandro Latini
    Principal Support engineer
    Delphix
    ------------------------------



  • 3.  RE: Using fixed result in Character Mapping

    Posted 06-11-2021 01:23:00 PM
    Thanks a lot for response Sandro, this might solve my problem.

    ------------------------------
    Rahim Cetinel
    Lead DataOps Architect | Delphix Blackbelt
    ------------------------------



  • 4.  RE: Using fixed result in Character Mapping

    Posted 06-12-2021 11:42:00 AM
    Hi everyone,

    I have tried the SELECT REGEXP_REPLACE function in the Rule Set, and customized the table I wanted to mask.

    The Select operation itself easily brings the values masked using an SQL function.

    Is there any way to update these values as masking operation?


    ------------------------------
    Rahim Cetinel
    Lead DataOps Architect | Delphix Blackbelt
    ------------------------------