GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 24 of 390    Print  
What r XML files and how do you read data from XML files and what stage to be used?

  
Total Answers and Comments: 4 Last Update: December 29, 2008   
  
 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   #1  
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 | NoAnswer is useful 0   Answer is not useful 1Overall Rating: -1    
May 06, 2007 22:38:56   #2  
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   #3  
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
December 29, 2008 06:08:08   #4  
tisha24 Member Since: September 2008   Contribution: 10    

RE: What r XML files and how do you read data from XML files and what stage to be used?
XML files can be read using FOLDER stage followed by XML input stage in server jobs.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape