This content has been marked as final. Show 2 replies
Actually, I just found the following Oracle note sums this up: 757642.1
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:
Such an approach must be avoided. This is a strict limitation of the ODI XML Driver.
See Bug:8563428 DUPLICATE SUBELEMENTS WITH DIFFERETNT TYPES ARE NOT SUPPORTED BY XML DRIVER