Masking on same table with multiple where clauses is not working

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

FDM not masking with multiple masking rules. 

When applying masking on same table with multiple where clauses, it is only masking last  columns with where condition.

Environment

Release : 4.9, 4.10

Component : CA Test Data Manager - Others

Resolution

When there is no primary key/unique key on a table, it is not masking the column correctly.

Please create a primary key on the table or define a column name as Unique column in masking and re run the masking job