Delphix Products

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

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

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

Thanks a lot Mayank and Mouhssine. I did the same you suggested and worked.