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?

Requirements: 
* 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 SUBSET03AUGUST2018.zip.  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.

Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html.