Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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....
Parsing the whole document within one job is sometimes essential to write in the database in one transaction.