My Oracle Support Banner

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 12.1.3.0.1 and later
Information in this document applies to any platform.

Goal

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.

Note: This difference can cause the mapping to fail when a string value contains special characters and is full length. For example: with WE8ISO8859P1 charset, special chars are stored in 1 BYTE but in AL32UTF8 the same special chars are stored in 2 BYTES. If the C$ table is created in ODI 12c with the source definition (CHAR xx BYTE) the string is out of length in xxxx instance. With ODI 10g the C$ table is created with NCHARS instead and the problem doesn't.

The l o c a t i o n of the C$ table is not different between ODI 11G and ODI 12C.

What is different in ODI 12C are the names and datatypes of columns:

- 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

The staging area where the C$ gets created remains unchanged if the SQL is implemented on the LKM "Command on Target" tab

-- in both ODI 11G, and ODI 12C, the C$ table will be created in the staging of target Datastore

If the LKM however implements a SQL in the "Command on Source" tab, then indeed, there will be a change of location between ODI 11G and ODI 12C:

-- in ODI 12C, this now will be executed in the staging of target Datastore

The change is noted by looking at the AP node ( Access Point node ) in ODI 12C Mappings - it resides on the target workspace.
Why does ODI 12C use the source definition instead of the destination definition, like it did in ODI 10G/11G?
Isn't it normal behavior that the generated code should use target definition?
Why do the ODI versions behave differently?

Solution

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.