Hierarchical Data Stage map all elements to single output

[ecclesr]

Our source XML data has multiple records with each record having nested listed elements

We are required to map all the listed elements fo a given record to a single output for each record

Using the Hierarchical Data Stage we are limited to mapping 1 level.

Is there a different approach we should be considering to meeting the requirement?

Thanking you all in advance

[kduke]

I have done this a lot. I have never found a good reliable way to do this without processing one level at a time until all levels were processed.

If you can load into Oracle or some database that can do the recursive SQL for you then you have to do it one level at a time.