using SQL function in FDM shows NULL results

Article Id: 130420

Status: Published

Updated On: 03-04-2019 06:23

Products:

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction:

While trying to mask SQL columns in Fast Data Maker using SQL functions and you are seeing the Results as NULL

Environment:

All supported versions of FDM

Resolution:

Make sure you un-check "Keep Nulls" for SQL Functions . Keeping NULL means that if target column have null values, keep them as is.