My Oracle Support Banner

Impacts of the Physical Architecture on Performance of ODI Mappings and Integration Interfaces (Doc ID 424343.1)

Last updated on NOVEMBER 21, 2023

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Goal

The execution of an Oracle Data Integrator (ODI) Mapping / Integration Interface is excessively slow, despite the fact that both the staging area and target Datastore are physically on the same Data Server.

Further analyze of the execution demonstrates that ODI uses a resource intensive loading phase.

Is the loading phase really necessary and how is it possible to optimize the operation?

The article applies to all releases of ODI like the current 12C as well as to previous releases.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.