- Back to Home »
- Loading same table asynchronously
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.
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.
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")%>
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")%>