RE: What r XML files and how do you read data from XML...
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.
RE: What r XML files and how do you read data from XML...
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.