Conversion of XML file to CSV file

suneyes · Post by **suneyes** » Mon Aug 04, 2008 3:18 am

Hi,
We have a requirement for conversion of an XML file to a CSV file with some transformations in the middle .
I didn't find any file stages related to an xml file in my version of datastage(7.5.1A).
Can any body enlighten me about how it can be done.

Any kind of help is very much appreciated. :D

chulett · Post by **chulett** » Mon Aug 04, 2008 7:01 am

Welcome! :D

Are you saying your installation does not have the XML Input, XML Output and XML Transformer stages available? If that's the case, then whomever performed your install chose not to include them for some reason. To solve this, rerun the install script and choose "Install additional plug-ins".

suneyes · Post by **suneyes** » Mon Aug 04, 2008 11:14 pm

Hi craig,
Thanks for the reply.

I have found xml plugins in my DS.
I tried using a folder stage as an input stage to XML input stage.but it is possible only in a server job. but our requirement is to use a parallel job.
can anyone help me with the way we can feed an xml file to an XML input stage in a parallel job.

there is only one xml input file which needs to be converted into a CSV file with some transformations in the middle.

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Mon Aug 04, 2008 11:59 pm

Challenge the requirement to use a parallel job. You are reading ONE FILE, a sequential operation. You are writing ONE FILE, a sequential operation. Parallel execution is a waste of time in this case, and you don't need the unnecessary overheads thereof. Server jobs will be supported into the indefinite future (minimum five years, probably much more, not least because job sequences are server jobs, but also because there are lots of customers out there using them) - that statement was made by IBM's world wide product manager for DataStage at last year's Information on Demand conference.

chulett · Post by **chulett** » Tue Aug 05, 2008 12:45 am

As noted, use a Server job for this task.

suneyes · Post by **suneyes** » Tue Aug 05, 2008 5:15 am

atlast I implemented the the conversion of XML file to CSV without a transformer.

need to incorporate business rules in the transformer.
Thanks all for ur valuable inputs.
:D

scorpion · Post by **scorpion** » Wed Sep 10, 2008 3:57 am

Hi Sun,

Could u Just explain the group how u implemented this?

thanks,
sampath

chulett · Post by **chulett** » Wed Sep 10, 2008 7:31 am

Sampath - please start your own post. That way we know your particulars and you can explain what problem you are facing. Include details. Many details. And leave 'U' out of it.

DSXchange

Conversion of XML file to CSV file

Conversion of XML file to CSV file

wheater to use a server job or a parallel job

Thanks for your valuable suggestions