tDataMasking - Masking Name

[Anonymous]

Hi,

I have customer data which has id, name, sex and address.

I wanted to anonymise the name based on sex. I have seed file with list of male names and female names.

Using tDataMasking is there a way to tell for Male look into male name file and for Female look into female name file.

Or is there a better approach.

I am looking for file since the replacement depends on hash value and the anonymisation will be consistent across all tables using the same file. 

Thank you. 

[dprot · Accepted solution]

Hi,

What you can do is the following job:

use one tMap before the tDatamasking component to duplicate your name column, then in the tDatamasking, you apply it on one name column with the Male file, and on the other name column with the Female file.

Once it's done, you can use a second tMap in order to merge the two columns according to the sex:

and you get the expected result.

Damien

[Anonymous]

Thank you.

It looks doable. Let me try before I accept this solution.