Datastage XML
Moderators: chulett, rschirm, roy
Datastage XML
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
-
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney
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.
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.
Prakash Dasika
ETL Consultant
Sydney
Australia
ETL Consultant
Sydney
Australia
That was the exact thread I found and used to help me get started using XML input.Ravi.K wrote:Use the below thread for XML file reading at Parallel Jobs.
viewtopic.php?t=138188&highlight=XML
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872