Delphix Products

 View Only

  • 1.  Masking function to Concatenate the Masked_First_Name and Masked_Last_Name

    Posted 06-09-2021 01:22:00 AM
    Hi Team,

    We have applied to mask on the first name and last name, there is one more Column i.e. Full Name.
    We want to concatenate the masked Value of First_Name and Last_name for this column. Request you to please suggest how to achieve this. Thanks,

    ------------------------------
    NITIN DIXIT
    Senior Tdm Admin, Data Privacy Solution Architect
    Delphix Community Members
    ------------------------------


  • 2.  RE: Masking function to Concatenate the Masked_First_Name and Masked_Last_Name

    Posted 06-09-2021 01:29:00 AM
    I am trying to achieve this using the PostScript functionality. Just to include a Simple update script as below:

    Update <table> set FULL_NAME = FIRST_NAME ||','|| LAST _NAME;

    Please suggest if this will work or not? Or please suggest to me any other way do this. Thanks,

    ------------------------------
    NITIN DIXIT
    Senior Tdm Admin, Data Privacy Solution Architect
    Delphix Community Members
    ------------------------------

    Original Message


  • 3.  RE: Masking function to Concatenate the Masked_First_Name and Masked_Last_Name

    Posted 06-09-2021 09:52:00 AM
    Edited by Sandro Latini 06-09-2021 09:56:17 AM

    Hi Nitin,

    If you are able to upgrade to Maskin version 6.0.8.1 (latest), you can take advantage of our new Name and Full name framework which will allow you to achieve your goal without using a postscript.

    More information are available in our documentation here: 
    https://maskingdocs.delphix.com/Securing_Sensitive_Data/Algorithms/Algorithm_Frameworks/Full_Name/

    Regards
    Sandro



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

    Original Message


  • 4.  RE: Masking function to Concatenate the Masked_First_Name and Masked_Last_Name

    Posted 01-29-2025 07:21:00 AM

    Hello Sandro,

    I have the same use cause but i need to add a prefix like (MR or MISS) depending on the gender,

    Could you please suggest me how to achieve this outcome?

    Thank you



    ------------------------------
    Yassine Taki
    Consultant
    Deloitte US
    ------------------------------

    Original Message


  • 5.  RE: Masking function to Concatenate the Masked_First_Name and Masked_Last_Name

    Posted 01-30-2025 02:11:00 AM

    Delphix by PERFORCE Professional Services developed a masking plugin which offers a number of features specific for Name masking (plugin MC_NAMES). For example it can detect gender either by column or by the name itself and uses separate male/female lookup lists. This plugin could be tuned to add a title or preserve a title if it already exists. Please get in touch with your customer success manager and refer to me. 



    ------------------------------
    Tino Pironti
    Masking SME
    Technical Manager
    Delphix
    ------------------------------

    Original Message


Related Content