Work Table Definition Changes Between ODI 10G/11G and ODI 12C
(Doc ID 2286222.1)
Last updated on AUGUST 23, 2023
Applies to:Oracle Data Integrator - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
In Oracle Data Integrator (ODI) 12C it has been observed that work tables are created on a source system rather than on the target as it was in ODI 10G, and ODI 11G.
The l o c a t i o n of the C$ table is not different between ODI 11G and ODI 12C.
- in ODI 11G, names and datatypes were taken from the target Datastore definition
- in ODI 12C, names and datatypes are taken from the source Datastore definition
-- in both ODI 11G, and ODI 12C, the C$ table will be created in the staging of target Datastore
-- in ODI 12C, this now will be executed in the staging of target Datastore
Isn't it normal behavior that the generated code should use target definition?
Why do the ODI versions behave differently?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!