Each time you save a mapping, the Mapping Designer validates the mapping.
When you save a mapping, check the status to see if the mapping is valid. Mapping status displays in the header of the Mapping Designer.
If the mapping is not valid, you can use the Validation panel to view the location and details of mapping errors. The Validation panel displays a list of the transformations in the mapping. Error icons display by the transformations that include errors.
In the following example, the Accounts_By_State Target transformation contains one error:
Tip: If you click a transformation name in the Validation panel, the transformation is selected in the Mapping Designer.
Validating a mapping
Use the Validation panel to view error details.
1To open the Validation panel, in the toolbar, click Validation as shown in the following image:
Error icons appear by the transformations that include errors.
2To view the list of errors for a transformation, click the down arrow, as shown in the following image:
3To refresh the Validation panel after you make changes to the mapping, click the refresh icon.
Validating a mapping in SQL ELT mode
In SQL ELT mode, Data Integration validates a mapping using additional rules that don't apply to mappings in other modes.
In SQL ELT mode, validation errors can result due to the following circumstances:
•The mapping contains multiple flows or pipelines.
•The mapping contains a transformation that doesn't appear in the Transformations palette in SQL ELT mode. For example, if you paste an unsupported transformation onto the mapping canvas, a validation error occurs.
•The target connection type or target connection parameter type isn't a supported target connection type. For more information about supported targets, see Mappings in SQL ELT mode.
•The target has named fields, but the field mapping is set to Manual. The field mapping must be Automatic, Partially Parameterized, or Completely Parameterized.
•The source connection or source connection parameter type isn't valid for the target connection type. For more information about supported sources and targets, see Mappings in SQL ELT mode.
•The source and target are in the same cloud data warehouse but they use different connections.
•The mapping contains a Sequence transformation that isn't directly connected to a downstream Expression transformation or target.
•A Sequence transformation is connected to multiple downstream transformations or targets.
Validation errors can also occur when there's a problem with the source, target or lookup connection. For more information, see the appropriate connector guide.
