While using a custom seedlist and using HASHLOV on a column different from the column being applied, the value always results in null no matter what the input is.
Fast Data Masker
Reviewing the TDM documentation and analyzing the results from the imported custom seed list inside the gtrep repository, we noticed is the first names are all showing as NULL. This is because the CSV file structure is off, and FDM is picking up the "name-value" pair as <firstname>,NULL. Causing the masking to always return the value NULL.
Looking at the first record in the example CSV (Line 2) we see:
CUSTOM_PERSON_NAMES,Dante,NULL,Brown,Smith,"Smith, Dante Brown",Dante B Smith,Dante B. Smith,Dante Brown Smith,Dante Smith,[email protected],71186
Where CUSTOM_PERSON_NAMES is the Category Name and all remaining comma-separated fields are considered name-value pairs. Resulting in the following
Name | Value |
Dante | NULL |
Brown | Smith |
"Smith | Dante Brown" |
Dante B Smith | Dante B. Smith |
Dante Brown Smith | Dante Smith |
[email protected] | 71186 |
Please refer to the TDM documentation: Propagate Seed List Data Across Masking Engines
------------------------------------
To resolve the reported problem, we need to strip the header row from the CSV, restructure the file into Name/Value pairs, and reimport the corrected seed list into the scramble database. Then rerun the masking job.
For the exact steps, please refer to "Propagate Seed List Data Across Masking Engines"