Unified masking function without hash column across the application database

book

Article ID: 222624

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 

Hi Team,

We are performing masking in a different application. And to make uniform masking in all the applications, we are using a hash column across the application.
But one of the applications is having flat files for masking. So while entering the same hash column value in flat file data, it is not updating the same data as of the other application.

For example:
Participant ID is the common key between the application, and while masking the Names we are updating the hash column value as Participant ID across the application database.
The applications having database masking, it is updating the same value for Names but the application having Flat file masking, it is updating with a different value.

Could you please suggest to us the best way to proceed it further?

 

 

Cause

 

The field names in the flat file had non-alphanumeric characters which caused a problem.

Environment

 

FDM 4.9.1

Component : Fast Data Masker

Resolution

 

In the example provided by the client, the layout.txt had a field called "PARTICIPANT'S SSN"
This was changed to "PARTICIPANT-SSN"

The ' and space in the name caused the problem. 
once these were removed the masking then worked as expected.

 

Additional Information

 

Layout.txt
HEADER=0,TRAILER=N,DELIM=FIXED,DATEQUOTED=,CHARQUOTED=,NUMQUOTED=  
REC-TYPE,2
PARTICIPANT'S SSN,9
NAME,30
FILLER,1

name issue.csv
Table,Column,Function,Parm1,Parm2,Parm3,Parm4,Keep Nulls,Date Format,Cross Reference,Override SQL,Unique Columns,XPath Element,Substr start,Substr length,Notes,Preformat,Update,Use Masked Values,Restart Column,From Occurance,To Occurance,Parm5,Parm6,Parm7,Parm8,Parm9,Parm10
,PARTICIPANT'S SSN,FORMATENCRYPT,,,,,Y,,,,,,,,,,,,,,,,,,,,
,NAME,HASHLOV,Voya_Names,3,PARTICIPANT'S SSN,,Y,,,,,,,,,,,,,,,,,,,,