Creating XML from multiple tables with one to many relations

[edmtenzing]

My XML file has got multiple levels which is sourced from number of database tables. For example;

Code: Select all

<A>
    <B\>
    <C\>
    <D>
         <E>
         <E>
     <\D>
    <D>
         <E>
         <E>
     <\D>
<\A>

There are many elements and there could be up to 20 children for an element. Depending on the requirement, the number of children can change. I have access to the XSD and the source will stay as it is.
Is there a best practice on how to create a complex XML file using DataStage? And if there is one, can it be redesigned quickly if the design changes?

[eostic]

Search thru the forum here. Find the "XML Best Practices"....link to kduke's site where you can find it. It goes into detail on how to create complex, multi-node XML. It's not particularly easy, but it can be done.

Ernie