My Oracle Support Banner

What Are the Impacts of Having Duplicate ELEMENTs as Different SubElements of XML Files on the Processing of the ODI XML Driver (Doc ID 757642.1)

Last updated on OCTOBER 24, 2023

Applies to:

Oracle Data Integrator - Version 10.1.3.4.0 to 11.1.1.6.5 [Release 10gR3 to 11gR1]
Information in this document applies to any platform.

Goal

NOTE: In the examples below, the names represent a fictitious sample for clarity. Any similarity to actual environments, past or present, is purely coincidental and not intended in any manner.

In Oracle Data Integrator (ODI), is it possible to use the SAME ELEMENT as a SUB-ELEMENT in multiple, different Elements of an XML File?

If so, what is the impact of this approach on the reverse engineered Model and Datastores and how can Integration Interfaces be set up to map these identical ELEMENT for which the content is semantically different and as a result to be used differently in different Oracle Data Integrator (ODI) Integration Interfaces.

The following XML is a simple example in which the ITEM Element is logically set as a sub-element to three other XML Elements:

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.