Page 1 of 1
Datastage XML
Posted: Sat Sep 10, 2011 8:54 pm
by kogads
Can anyone explain how to read xml files in Datastage parallel jobs , i saw a lot of posts which mention how to output to xml stage and also reading through a folder stage in server jobs but i dont see how to read xml files in parallel jobs any where ... any help is appreciated .Thanks
Posted: Sat Sep 10, 2011 10:02 pm
by chulett
Posted: Sun Sep 11, 2011 8:16 pm
by prakashdasika
You can use a external source stage as specified by Ernie in his blog or do the same thing using a wrapper stage (custom stage) and do a 'ls' to get the xml file and in the input tab of XMLInput stage select the source as 'URL/Path'.
If the name of file remains same then you can also have a transformer with a column that contains the path (including the name of the file) which will be input to the XMLinput stage. This stage should also have a dummy Row Gen stage.
Posted: Tue Sep 13, 2011 10:04 am
by Ravi.K
Use the below thread for XML file reading at Parallel Jobs.
viewtopic.php?t=138188&highlight=XML
Posted: Tue Sep 13, 2011 3:05 pm
by FranklinE
That was the exact thread I found and used to help me get started using XML input.