The date format that CLAIRE recommends is the format occurring most frequently in the column fields. CLAIRE recommends a date format when it occurs 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. 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. In the mapping canvas, connect the Expression transformation to the data flow.

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

Decline

.

Data Integration

removes the recommended Expression transformation from the mapping canvas.