Best Approaches for Performance Optimization Strategies for ODI Scenario Execution
(Doc ID 423726.1)
Last updated on JUNE 15, 2023
Oracle Data Integrator - Version 3.2.03.01 and later Oracle Data Integrator on Marketplace - Version 1.0.2 and later Data Integration Platform Cloud Classic - Version 17.3.5 and later Oracle Data Integrator Cloud Service - Version 17.1.3 and later Information in this document applies to any platform.
Solving data integration problems with Oracle Data Integrator (ODI) may raise questions about how to best achieve performance and scalability.
The fact that Oracle Data Integrator (ODI) Scenario execution is usually very fast is largely due to its E-LT architecture which makes use of native DBMS SQL and native DBMS utilities such as bulk loaders, unloaders and complex set-based transformations. However, despite the use of such native features some performance issues may be encountered.
This document therefore discusses performance and scalability questions and describes optimization solutions.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!