how can import and map multiple table from single XML

[Anonymous]

Hello everyone,

i am start working on XML metadata, i have an issue to import multilevel XML into tables,

do i need to process one table at a time or any other options are available for XML.

i have attached sample schema of XML

Thanks in advanced

[David_Beaty]

Hi,

If you are processing an XML document with multiple sets of repeating sections - at different levels within the document, you'll need to process it at each level separately.

Thanks

David

[jlolling]

It is possible. I would use the tExtractXMLField.

Here a real life use case in which on every level we iterate and extract the next level as Document and hand over to the the next tExtractXMLField and so on....

[jlolling]

Parsing the whole document within one job is sometimes essential to write in the database in one transaction.