My Oracle Support Banner

After Reverse Engineer of XML Only Last Element of Nested Sequence is Imported into ODI Model (Doc ID 2458922.1)

Last updated on FEBRUARY 27, 2019

Applies to:

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

Symptoms

In Oracle Data Integrator (ODI) 12c, reverse engineering an XML file, followed by viewing the data of the resulting model, shows that when there are nested repeated elements only the last row is displayed.

For example, the XML data contains the followings structure:

<TABLE_NAME>
 <COLUMN_NAME>123</COLUMN_NAME>
 <COLUMN_NAME>124</COLUMN_NAME>
 <COLUMN_NAME>125</COLUMN_NAME>
 <COLUMN_NAME>126</COLUMN_NAME> 
</TABLE_NAME>

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Using "maxOccurs"
 Using "useImplicitMaxValue" in JDBC URL
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.