How To Set Up Simultaneous Launching of Multiple Parallel ODI Integration Interfaces (Mappings) That Feed The Same Target Datastore
Last updated on SEPTEMBER 25, 2017
Applies to:Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.
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?
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