CLAIRE recommends that you replace NULL values when NULL appears in more than 85% of the column fields. When a recommendation is available,

Data Integration

highlights the

Recommendations

tab. Select the

Recommendations

tab to see the recommendations.

In the list of recommendations, click the

Show Me

icon for the expression that you want to investigate and then enter a preview value. An Expression transformation appears on the mapping canvas linked to the associated source.

If you want to use the expression, in the

Recommendations

tab, click the

Accept

icon. Then, enter the value you want to use in place of NULL. In the mapping canvas, connect the Expression transformation to the data flow.

If you don't enter a value, CLAIRE replaces NULL values with a default value based on the data type. The following table shows the default values CLAIRE uses:

Data type	Default value
String	default
Integer Bgint	0
Date	Current system time
Decimal Double	0.0
Binary	0

If you don't want to use the recommended expression, click

Decline

.

Data Integration

removes the recommended Expression transformation from the mapping canvas.