My Oracle Support Banner

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 MARCH 25, 2024

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 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

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.