ODI 12c Mapping Using "Component Context (Forced)" Generates the C$ Temporary Table on Incorrect Physical Schema
(Doc ID 2824699.1)
Last updated on AUGUST 07, 2024
Applies to:
Oracle Data Integrator - Version 12.2.1.4.211011 to 12.2.1.4.221215 [Release 12c]Oracle Data Integrator on Marketplace - Version 12.2.1.4.211011 to 12.2.1.4.221215
Information in this document applies to any platform.
Symptoms
An Oracle Data Integrator (ODi) 12c Mapping having the target Datastore "Component Context (Forced)" Logical design option set to a value other than <Execution Context>, uses incorrect Physical Schema during the loading (LKM) phase.
If the source Datastore is on FILE technology, and the target Datastore on some database, the following error is received while deleting / creating the C$ table:
To replicate the behavior:
- Create a Mapping that has two source Datastores: one FILE, and one Oracle.
Set the target to a Datastore in same Model as the source Oracle Datastore.
Set a Filter on the Oracle source Datstore, and a Join between the two Dataastores.
Set the knowledge modules to be used:
LKM File to SQL, and
IKM SQL Control Append
- Leave the "Component Context (Forced)" of the target Datastore to its default value (which is <Execution Context>).
Execute the Mapping, and observe the C$ created on the target (Oracle) Working schema, using <DB SCHEMA>.C$ name / syntax.
This is correct / desired behavior.
- Edit the Mapping, and change the "Component Context (Forced)" of the target Datastore to "Global" (or another Context where the involved Physical Schemas / Logical Schemas have been mapped).
Execute the Mapping, and observe the C$ created on the source ( FILE ) Working schema, using <FILE PATH>.C$ name / syntax.
This is incorrect. The same works just fine in ODI 11g
Changes
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! |