Mappings

Back Next

Validating a mapping in advanced mode

In advanced mode, Data Integration validates the mapping based on how an

advanced cluster

processes the data. When you copy a mapping to advanced mode, the

Validation

panel shows validation errors that the

advanced cluster

checks for.

Validation errors can result from the following differences in advanced mode:

Transformation differences: The transformation palette uses a different set of transformations, so some transformations might no longer be available. Some transformations have a different set of properties that you need to configure, or previously-configured properties might no longer apply.

You might need to reconfigure properties, rearrange the transformations, or replace transformations in the data flow. For example, the Sorter transformation can only take effect in advanced mode when it is directly upstream from the Target transformation.

For more information, see
Transformations
.
Function differences: The expression editor uses a different set of functions. Function return values can differ, and some functions require additional arguments. For example, the TO_DECIMAL function requires the scale argument in advanced mode.

For more information, see
Function Reference
.
Data type differences: Some data types are processed differently. For example, an
advanced cluster
uses stricter rules to validate and process decimal data types.

For more information, see
Function Reference
.
Connector differences: An
advanced cluster
accesses some connectors differently than the Data Integration Server. You might need to configure details in the connection properties so that the cluster can access and process the data source.

For more information, see the help for the appropriate connector.