Delphix Products

Expand all | Collapse all

What is the best algorithm to mask a column which have "Last Name, First Name (Location)"?

Jump to Best Answer
  • 1.  What is the best algorithm to mask a column which have "Last Name, First Name (Location)"?

    Posted 03-26-2019 08:56:00 AM
    What is the best algorithm can be used to mask a column which have "Last Name, First Name (Location)"?
    Eg:
    If a column named as DISPLAYNAME with below fields are there and want to know the best way to mask it.
    Clifford, Patrick (US - Retired)
    Dagnelie, Paul (Boston)
    Rupp, Michael (Dallas)
    Seo, Yeonok (Boston)
    Duff, William S. (Dallas)

    FYI,
    I have a algorithm with LASTNAME_COMMA_FIRSTNAME_SL(Secure Lookup). 
    Now I want to know if this algorithm can be used for masking name alone and then apply Secure Shuffle to Location which means applying two algorithms on the same column. If so how it is possible.
    Or any other approach to mask this?

    Kind Regards,
    Rajesh
    #Masking


  • 2.  RE: What is the best algorithm to mask a column which have "Last Name, First Name (Location)"?
    Best Answer

    Posted 03-26-2019 09:43:00 AM
    Hi Rajesh,

    In my view the easiest way to mask this is to create a Secured Lookup which has values for LASTNAME,FIRSTNAME (LOCATION). Sample values like :

    Dadi,Rajesh (Boston)
    Schumacher,Michael (Dallas)

    Please let me know if there are concerns with this solution.


    Regards,
    Mayank


  • 3.  RE: What is the best algorithm to mask a column which have "Last Name, First Name (Location)"?

    Posted 03-26-2019 10:20:00 AM


    Hi Rajesh,

    In my view Mayank is right, you will have only one pass to get all columns masked, but this solution implies generation a secure lookup file.

    You solution will need 3 passes masking fist_last_names (1), secure shuffle city (2), update first_last_names_cities column (3).

    Regards,

    Mouhssine



  • 4.  RE: What is the best algorithm to mask a column which have "Last Name, First Name (Location)"?

    Posted 03-29-2019 07:36:00 AM
    Thanks a lot Mayank and Mouhssine. I did the same you suggested and worked.