FDM is not masking 'NULL' values even when the "Keep Null" check box is unchecked.
search cancel

FDM is not masking 'NULL' values even when the "Keep Null" check box is unchecked.

book

Article ID: 260694

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Even after Unchecking Keep Null, values are not being populated

Environment

Release : 4.10

Cause

With further investigation, we found that the columns in the database were empty/blank, but they were not NULL, which is why the masking was not happening.

In order for the "Keep Null" parameter to work properly, the field must be NULL; meaning there hasn't been any memory allocated to it yet.

The main difference between NULL (Unknown) values is there has been any memory allocated from the database yet. When a value is Empty or Blank, there has been allocated memory (length 0), and therefore the value is not NULL. This is why NULL values are treated differently than empty/blank values.

Resolution

Once we set the value of the column to NULL, the masking worked.

Additional Information

https://sqlskull.com/2019/12/10/null-vs-blank/