| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: What r XML files and how do you read data from XML files and what stage to be used?
|
| July 07, 2007 08:24:37 |
#3 |
| satya |
Member Since: Visitor Total Comments: N/A |
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. |
| |
Back To Question | |
