TDM: FormatEncrypt and other FDM Rules for Transformation Maps


Article ID: 110130


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


I have a mask rule in FDM using the FORMATENCRYPT function. I have applied the rule to an identification column, which needs the format preserved and keep the unique values, because is a personal identification data. The masking needs to starts at position N (in this case 2). How I can use the a mask rule in Transformation Maps that keep up the integrity with the mask that I did in FDM with FormatEncrypt and comply our needs?

* Preserve the format 
* Keep the unique values 
* The mask start at position N 
* Keep the integrity with FDM. 

I check step by step the process and it creates the temp table with the values but it is always put the value "NOCNT".


TDM 4.5


This has been fixed in  Please contact CA Support for this or a later release.  Please contact CA Support to verify that this fix made it into the GA Release after August 5, 2018.

Additional Information

Video URL on how to open a Support Case -

You can download the latest version of TDM by following the directions in this document:   

To contact support, go to