My Oracle Support Banner

ODI Dimension Operator Provides Less Efficient Code than OWB Dimension Operator (Doc ID 2674198.1)

Last updated on JANUARY 16, 2024

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 to 12.2.1.3.190708 [Release 12c]
Information in this document applies to any platform.

Symptoms


After migrating Oracle Warehouse Builder (OWB) to Oracle Data Integrator (ODI), there is significant performance degradation observed in ODI when comparing the executions. Upon review it would seem the ODI Dimension operator provides less efficient code than OWB Dimension operator. 

 

Cause

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.