ODI Pundits - Oracle Data Integrator

This problem is on the older version of ODI (10g) . This issue is mitigated by default in the newer version of ODI 12c and some versions of 11g.

The Problem:

When you load a the same target table across two interfaces which run in parallel. We have an issue in with the load.We will get a conflict in the I$tables, as the I$ tables are created with based on the target table name. Since the target table is same across both the interfaces. We will have clash of the table names.

The Solution:

So should append session numbers to the I$ in topology..

Topology > Physical Architecture > Technology (Oracle) > Advanced > Default Integration Table Prefix

Change value to I$_<%=odiRef.getSession("SESS_NO")%>

Pitfall:

Cannot run the same interface in parallel in the same session.