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

Validating a mapping in advanced mode

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.

0 COMMENTS

We’d like to hear from you!