TDM: FormatEncrypt and other FDM Rules for Transformation Maps

Document ID : KB000110130
Last Modified Date : 09/08/2018
Show Technical Document Details
Issue:
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".
Environment:
TDM 4.5
Resolution:
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.
Additional Information:

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