how to convert a flat file into an XML file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
saurabhduggs
Participant
Posts: 1
Joined: Wed Dec 28, 2005 5:18 am

how to convert a flat file into an XML file

Post by saurabhduggs »

i m working on data stage version 9, the problem is i think iam missing something in xml file?
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Cool, can you tell us a bit more about Version 9 :shock: ? (the current version is 7.5)

What is your issue exactly, you normally can go from a sequential file to an XML stage, even at versions < 9.
MaheshKumar Sugunaraj
Participant
Posts: 84
Joined: Thu Dec 04, 2003 9:55 pm

Post by MaheshKumar Sugunaraj »

Hi,

As stated could you pls tell about Data Stage version 9?? :?:

About working on XML Stage:

If you need to load the Flat file data into the XML format, you need to have the meta data of the XML file u want to create i.e., the XSD i.e XML Schema file definition using which you could create the XML files.

Seq. file stage ---->Transformer -------> XML Output Stage

If you have the XSD then you could generate the same. In order to get the XSD you could use XML Meta Data importer which would give the XSD of the file.

Hope the above is clear.

Advance New Year wishes.

With Regards
Mahesh
Post Reply