ODI Mapping Execution Ignoring Oracle Database Hints
(Doc ID 2861321.1)
Last updated on APRIL 13, 2022
Applies to:Oracle Data Integrator - Version 188.8.131.52.190415 and later
Information in this document applies to any platform.
When adding hints to an Oracle Data Integrator (ODI) mapping, the hints are ignored and not sent to the database with the query.
For example, the following two examples are different hints added for the performance improvement of a fact table. When executing the mapping with these hints (@SEL$3 and @SEL$30) they are not included.
Hints as declared:
Note that in the execution log, the hints @"SEL$3" and @"SEL$30" are missing.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document