Posted by : Arjun Lagisetty Wednesday, September 16, 2015

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. 

Leave a Reply

Subscribe to Posts | Subscribe to Comments

Popular Post

Labels

Blog Archive

Copyright © ODI Pundits - Oracle Data Integrator - Maintained by Arjun Lagisetty