After Reverse Engineer of XML Only Last Element of Nested Sequence is Imported into ODI Model
(Doc ID 2458922.1)
Last updated on OCTOBER 04, 2022
Oracle Data Integrator - Version 22.214.171.124.0 and later Information in this document applies to any platform.
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:
The model table TABLE_NAME has "Column_name" as column.
A "View data" of TABLE_NAME only shows one row, the one with column_name value 126.