Null Value Handling

Null values may exist for fields that have been defined as nullable within the column definition of the DBMS.

The following options are provided to allow you to specify how to handle null fields. Only one choice is allowed.

Choices include:

• Retain: (default) Null values in the source are valid and will not be replaced.
• Replace: Allow null source values to be replaced.
• Invalid: Null values in the source data are invalid.

Selection criteria within the rule can check for the null value condition by using the "is null" or "is not null" condition test. Based on that result, different actions can be taken if required.