Header repeatition in the XML file

sunita · Post by **sunita** » Mon May 16, 2011 6:39 am

Hi ALL,
We are generating a XML file reading the data from the oracle database and using the XML output stage in the data stage. we are importing the meta data from the XSD which has one root element and has 2 child elements which are defined as choice in the xSD. We are importing both the choice elements.
The problem is we are getting the XML generated with the repetition of headers in spite of selecting the non key element as the key other than the header elements.
Is there any option or way to avoid the header repetition.

Thanks.

ray.wurlod · Post by **ray.wurlod** » Mon May 16, 2011 3:19 pm

What has this to do with the DSXchange site/forum?

chulett · Post by **chulett** » Mon May 16, 2011 3:37 pm

Not a thing, so off we go to (hopefully) the appropriate place. Hang on!

sunita, can you edit your post to add the 'Required' information, please?

eostic · Post by **eostic** » Tue May 17, 2011 12:26 am

How is it not a dsXchange item? They are using ds to build xml..... isn't that a good thing?

.....hard to say exactly what your issue is, but put the "key" on an element (column) that is on the lowest level repeating node. It's usually and incorrect position of the "key" [it doesn't really mean a 'key' ...it simply indicates the repeating node] that results in duplicate headers and a not well formed document.

Ernie