Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a job that generate a complex XML file using tAdvancedFileOutputXML in append mode, the result is correct, but this component is extremely slow (for 15MB file size is like 4hrs !) this is due to their use of DOM4J instead a SAX parser.
So i tried this :
step 1 : To write different xml files, one for each loop in sax mode, very fast
step 2 : Merge the xml files with the tXMLMap, but the tXMLMap doesn't allow more than one loop.
Here is the example on my output_xml file :
Using TOS 5.5.1
How can a merge the xml files in a correct time ? or maybe Talend is not allow to do this ?
Thanks for your help.
I have a job that generate a complex XML file using tAdvancedFileOutputXML in append mode, the result is correct, but this component is extremely slow (for 15MB file size is like 4hrs !) this is due to their use of DOM4J instead a SAX parser.
So i tried this :
step 1 : To write different xml files, one for each loop in sax mode, very fast
step 2 : Merge the xml files with the tXMLMap, but the tXMLMap doesn't allow more than one loop.
Here is the example on my output_xml file :
<root>
<genericData>
<name>test</name>
<service>Service Name</service>
<serviceDesc>serviceDesciption</serviceDesc>
<Resp1>
<codeResp>aaa</codeResp>
<nomResp>bbb</nomResp>
</Resp1>
</genericData>
<survey> ---> Loop Element
<A>blabla</A>
<B>blingbling</B>
<surveyNodeInfo> ---> Loop Element
<surveyNodeInfoX>xxxx</surveyNodeInfoX>
<surveyNodeInfoY>yyyyy</surveyNodeInfoY>
</surveyNodeInfo>
<surveyNodeOtherInfo> ---> loop element
<surveyNodeZ>zzzz</surveyNodeZ>
<surveyNodeM>mmmmm</surveyNodeM>
</surveyNodeOtherInfo>
<sampling> ---> Loop Element
<C>blabla</C>
<D>blingbling</D>
<samplingNodeInfo> ---> Loop Element
<samplingNodeInfoX>INFO</samplingNodeInfoX>
<samplingNodeInfoY>OTHER INFO</samplingNodeInfoY>
</samplingNodeInfo>
<samplingNodeOtherInfo> ---> Loop Element
<samplingNodeW></samplingNodeW>
<samplingNodeU></samplingNodeU>
</samplingNodeOtherInfo>
<E>indformation node</E>
<sample>---> loop element
<F>blabla</F>
<G>blingbling</G>
<sampleNodeInfo> ---> Loop Element
<sampleNodeInfoS>INFO</samplingNodeInfoS>
<sampleNodeInfoT>OTHER INFO</samplingNodeInfoT>
</sampleNodeInfo>
<sampleNodeOtherInfo> ---> Loop Element
<sampleNodeC>CCCC</sampleNodeC>
<sampleNodeD>DDDDD</sampleNodeD>
</sampleNodeOtherInfo>
<H>indformation node b</H>
<sampleNodeJ> ---> Loop Element
<sampleNodeInfoJ>JJJJJJ</sampleNodeInfoJ>
</sampleNodeJ>
</sample>
<samplingNodeJ> ---> Loop Element
<samplingNodeInfoJ>JJJJJJ</samplingNodeInfoJ>
</samplingNodeJ>
</sampling>
<I>IIIII</I>
<surveyNodeJ> ---> Loop Element
<surveyNodeInfoJ>JJJJJJ</surveyNodeInfoJ>
<surveyNodeInfoJJ>KKKKKK</surveyNodeInfoJJ>
</surveyNodeJ>
</survey>
</root>
Using TOS 5.5.1
How can a merge the xml files in a correct time ? or maybe Talend is not allow to do this ?
Thanks for your help.
Hi,
Yes i already have this option
regards
Yes i already have this option
regards