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.
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.
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: