XML

[mannu]

Hi friends,

I am new to XML and have a requirement where I need to Publish 1000 recodrs and 70 column data from a single flatfile/database into an XML file.I don't have any other information as how the XML document should look like apart from flat file.so i used XML o/p stage. But in o/p ,for each column ,i do not want to specify the path manually... is there any to produce these XPaths in GUI given I just have all the records in .txt file .
for eg : in XMP o/p stage and in o/p page
col.A-varchar(50)-/customer/A/text()
col.B-char(10)-/customer/B/text()
In the above scenario, i don't want to manually type these path info for all 70 column?

Thank you.

[anbu]

Use XML metadata importer to import the metadata from your XML file

[chulett]

Best if you can get an xsd from whomever produced that file and import the metadata from that, but worst case you can use the XML as noted. Hopefully it is a complete representation of what your files will look like in the long run.

[Sreenivasulu]

You can generate the XSD from the xml file using xmlspy,xmlmarker etc

Regards
Sreeni

[ersunnys]

Mannu,

What I understood from your query is, target XML structure is not yet finalize (or could be Dynamic) but you want to give XML structure at run time...

For this, use XML Transform stage after XML Output stage and use XSL to write the structure of XML. You can modify this XSL anytime without touching the code and the XML output will be as per defined in XSL...