How To Set Up Simultaneous Launching of Multiple Parallel ODI Integration Interfaces (Mappings) That Feed The Same Target Datastore (Doc ID 423999.1)

Last updated on AUGUST 01, 2017

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.


Goal

Data integration processing requirements oblige the simultaneous launching of multiple ODI Mappings (Integration Interfaces) that feed the same target Datastore.

The concern here is that ODI creates identically named C$, and I$ temporary integration tables for both Mappings (Integration Interfaces) with the result that collision occurs.

This results in the occasional display of the following message: 'table missing'.

Is there a way of avoiding these messages and are there any best practices in running multiple concurrent and simultaneous Interfaces for the same target Datastore?

Solution

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 hundreds of Community platforms