Search code examples
xmldatastage

Datastage XML Generation Issue

For generation of new XML I had created an XSD first then created the job like below

Oracle connector>XML>XML_Output

In the edit assembly of XML stage>XML composer step I choose the option as "Write to File " and provided output file directory and Filename prefix

the issue I am facing is for each input row DS is generating seperate XML output files.(eg:10 XML files for 10 input rows) My requirement is to generate a single output XML file with all the input values.

Please help

Solution

  • Two recommendations:

    1. Check the Output -> Mappinng of the XML stage and assign the right level to the output link. Try assigning "top" to the name of the output link

    2. Use regular outputlink and do not let the XML Stage write directly to the file but use a separate Sequential File Stage