Mappings

Back Next

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.

Mapping validation

Download Guide

Watch

Comments

Cloud Data Integration Homepage