using SQL function in FDM shows NULL results

book

Article ID: 130420

calendar_today

Updated On:

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.