Test Data Manager

 View Only
  • 1.  Masking file

    Posted Jan 29, 2018 11:15 PM



    We are masking some csv file and we have a requirement to mask the birthday and the age field.


    How can we do this when masking a file?


    We tried masking the birthday and using SQLFUNCTION to calculate the age from : SYSDATE - BIRTHDAY but it does not work.





  • 2.  Re: Masking file
    Best Answer

    Posted Jan 30, 2018 08:33 AM

    Hi Francois, 


    For birthday and keeping original age you could use HASHDOB.

    Masking Functions and Parameters - CA Test Data Manager - 4.4 - CA Technologies Documentation  


    The HASHDOB function hashes a date, keeping the original age.

    Parameters: None

    Applies to: Date and Character

    Example: Date of birth is masked by hashing an existing date of birth. For example, the date in the column BIRTH_DATE is consistently masked (retaining the age) 2016-05-24 to 2016-05-28, 1999-12-16 to 1999-12-26. The following table shows the usage: