Test Data Manager

  • Private Community

  • 1.  TDM - File masking with duplicate values

    Posted Sep 13, 2018 03:38 PM

    Hi Team, Can you help with my scenario. I need to mask a flat file and in one of the column there could be duplicate values and after masking they want to keep the same masked values for both the records. But I do not have an unique identifier for each records. Any help much appreciated.

     

    Ex:

    1st record - A,Greg,EOF

    2nd record - B,Joe,EOF

    3rd record - C,Greg,EOF

     

    After masking

    1st record - A,JOHN,EOF

    2nd record - B,JACK,EOF

    3rd record - C,JOHN,EOF



  • 2.  Re: TDM - File masking with duplicate values

    Posted Sep 14, 2018 08:05 AM

    Hi Azarwin,

     

    You can use HASHLOV to mask the column having duplicate values. You need to have one seedlist for this. This technique will mask duplicate values as duplicate.

     

    You can get more about HASHLOV using below link.

     

    https://docops.ca.com/ca-test-data-manager/4-6/en/reference/masking-functions-and-parameters

     

     

    Regards,

     

    Vennlig hilsen



  • 3.  Re: TDM - File masking with duplicate values

    Posted Sep 14, 2018 04:19 PM

    Thanks Raju for the response.

     

    I'm familiar with HASHLOV and question was which field to hash on as there was no Identifier. Anyway I will try with hashing on the name itself, but the names has something appended to it like "Greg - A111". 

     

    Thanks

    Azar