XML file , need varying number of outputs files

alisoviejo · Post by **alisoviejo** » Fri Mar 03, 2006 10:01 am

Based on the source file which is an XML file, I need to create n number of output files using XSLT or other ideas. Does any one have experience doing that or can we not create files dynamically on the run based on the source data.

ArndW · Post by **ArndW** » Sat Mar 04, 2006 3:45 am

Aliso,

could you read the XML file into a DataStage job and then split your incoming data into several streams in a transform stage and output each of those to a XML output file of the appropriate format?

alisoviejo · Post by **alisoviejo** » Tue Mar 07, 2006 12:21 pm

Hi Andrw,

Yes, but the number of streams vary each time and the job needs to create the files on the run based on the source XML file, is it possible ?

ArndW · Post by **ArndW** » Tue Mar 07, 2006 2:19 pm

I can't think of a way to do that directly. I might approach this in a multi-pass system - the first pass gets all the possible file names into some list, then one more pass for each filename to filter the XML. Not necessarily efficient, but also not terribly complex to code.

vinaymanchinila · Post by **vinaymanchinila** » Wed Mar 08, 2006 3:14 pm

Hi Andrw,
Thanks for the thought and time. I did not get you when you say "the first pass gets all the possible file names into some list", so I am thinking, use a source XML Input Stage , then a XML Transformer and then ? how do I store the file names, basically the xslt will be generating different files itself.

Obviously new to this XSLT stuff ! Even though not efficient looks like an innovative idea

alisoviejo · Post by **alisoviejo** » Wed Mar 08, 2006 3:25 pm