What r XML files and how do you read data from XML files and what stage to be used?

Showing Answers 1 - 13 of 13 Answers

hanug

  • May 6th, 2007
 

First, u can use XML metadata importer to import the XML source definition.Once it is done. U can use XML input to read the XML document. For each and every element of XML , we should give the XPATH expression in the XML input.


XML stage document clearly explanins this.

Hanu.

  Was this answer useful?  Yes

satya

  • Jul 18th, 2007
 

This is how it can be done
Define the xml file path in the administrator
Under environmental parameters, import the xml file metadata in the designer repository.
Use a transformer stage (without an input link) to get this path in the server job.
Use the xml file input stage. In the input tab under the xml src, place this value from the transformer.
On the output tab you can import the meta data (columns) of the xml file and then use them as other input columns in the rest of the jobs.

  Was this answer useful?  Yes

introJ

  • Mar 25th, 2010
 

First import the columns through metadata importer for xml

Folder stage(Path for xml. or if it  doesnt  work put the xml file in the project directory)
   |
   |
XML Input Stage (Load columns from metadata  and here u have to provide xpath in description)
   |
   |
Sequential file or whichever stage u wish to use.


PS: Its a server Job.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions