Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapping tutorial
  4. Parameters
  5. CLAIRE recommendations
  6. Data catalog discovery
  7. Visio templates

Mappings

Mappings

Replace NULL values

Replace NULL values

If CLAIRE detects a large number of fields with NULL values in the source, it might recommend an Expression transformation that replaces the NULL values with a value that you define.
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.

0 COMMENTS

We’d like to hear from you!