Mappings

Back Next

Runtime plans

To troubleshoot a mapping in advanced mode, you can view the runtime plan when you monitor the job. The runtime plan shows which mapping logic runs on the Data Integration Server or on an

advanced cluster

When you run a mapping in advanced mode,

Data Integration

uses the mapping compilation log to create a visualization of the mapping logic at runtime. The visualization is available as a runtime plan that you can view in the job details.

The following image shows an example of a runtime plan:

The runtime plan includes two segments. The first segment includes the transformations that run on an advanced cluster. The transformations in the first segment link to another set of transformations in the second segment. The second segment runs on the Data Integration Server.

The runtime plan is a close approximation of how the data actually flows through the mapping at runtime. The runtime plan is generated after mapping compilation, so the transformations in the runtime plan might appear in a different order than in the designed mapping.

If a mapping runs using SQL ELT optimization, the mapping logic runs on the database, so a runtime plan isn't available.

For information about monitoring a mapping in advanced mode, see

Monitor

Mappings in advanced mode

Download Guide

Watch

Comments

Cloud Data Integration Homepage