Preserve Nulls Option


 If you want to preserve null values in a masked column then select the Preserve Nulls checkbox in the Masking view.

 

You can also access this setting using the popup menu (right-click) in the explorer tree and diagram.

 

Considerations

* This setting shall be disabled for columns whose DBMS data type definition specifies that it is not nullable.

* This setting is not available on columns that are members of a Column Group. This is because a Column Group means that all columns are masked together per row and therefore a column cannot be masked individually which also means that a preserve property cannot apply to an individual column of a Column Group. Therefore, you would use a Preserve mask and specify its Where condition to define the rows on which every column of the Column Group should be preserved.