Test Data Manager

  • 1.  Masking file

    Posted Jan 29, 2018 11:15 PM

    Hello,

     

    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.

     

    Thanks

     

    Francois



  • 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  

    HASHDOB

    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:

    TableColumnFunctionParm1Parm2Parm3
    EMPLOYEEBIRTH_DATEHASHDOB