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

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 24 of 380

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

Total Answers and Comments: 3

Last Update: July 18, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 24, 2005 18:17:57

mallakishore

Member Since: October 2005 Contribution: 7

RE: What r XML files and how do you read data from XML...

In the pallet there is Real time stages like xml-input,xml-output,xml-transformer

Is this answer useful? Yes | No

0 1

Overall Rating: -1

May 06, 2007 22:38:56

hanug

Member Since: June 2006 Contribution: 24

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.

XML stage document clearly explanins this.

Hanu.

Is this answer useful? Yes | No

July 18, 2007 08:24:37

satya

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.

Is this answer useful? Yes | No

Go To Top