source dataset ---> transformer stage ---> target XML file
The dataset has about 100,000 records and writing in to XML file is very slow. If i replace the XML file / sequential file, it would be faster. I would want to know is there any thing I miss when I am writing to XML or DataStage is slow writing to XML file?
Quantify "very slow" and "faster" without using rows/sec which, as I have established elsewhere, is an essentially meaningless metric. What volume of characters is written into a text file versus what volume of characters is written into the XML file? How much extra processing is needed to create the XML tags?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
For 146900 records, it takes 9 minutes and theres no logic involded in the transformerstage, it just converts the decimal column values to string. Transformer stage was here because, in the generated XML file the decimal column values are not appearing, if the datatype is decimal.
Apples and Oranges. The XML parsing is Java under the covers (Xerces based, IIRC) and not all that speedy. Be happy with your 9 minutes, there is plenty of 'logic' involved.
-craig
"You can never have too many knives" -- Logan Nine Fingers