Interested to Buy Any Domain ? << Click Here >> for more details...
How to convert table data into xml file using xml output
stage? please explain step by step;
- 2 Answers
- 19927 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / srinivas
Hi Mukti,
To load the data into XML file first you need import the xml metadata as you expected structure by using the .xsd file or .xml file.
While importing the structure you must careful about the structure and if any value is repeating then define as a key column.
For example in above xml structre child value is diffrent and parents are same for the three rows like below :
CHANGE NAME DATASOURCE ACTION VALUE
ADD MY GSDBDatabase READ 2011
ADD MY GSDBDatabase READ 2012
ADD MY GSDBDatabase READ 2013
in above table VALUE column is unique and other values are same Note: this is taken from XML definition on question i took only 5 columns because of space issue.
In this situation you should define VALUE column as key column in XML output stage.
Job structure should like below:
SourceStage ---->transformer ----> XML output Stage.
Note:Before loading data into XML file you must sort the data other wise order will be change, what ever order you have in source the same order will load in to XML file So these words are mindful.
If you face any problem please let me knoow.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the command line function to import and export the ds jobs?
Can we use target hash file as a lookup ?
What are the different types of lookups in datastage?
What is staging variable?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Can you explain engine tier in information server?
What are the difference types of stages?
Why do you need stage variables?
What is a merge?
Does datastage support slowly changing dimensions ?
What is a datastage job?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
