How to work with XML out put stage? Please explain step by
step? i need to generate XML file using Table data. Given
is the .XSD file. Please help?
Answer Posted / srinivas
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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to find value from a column in a dataset?
How many areas for files does datastage have?
What are the types of containers in datastage?
What are the different layers in the information server architecture?
What is usage analysis in datastage?
What is the command line function to import and export the ds jobs?
Describe link sort?
What are the types of jobs we have in datastage?
What is the difference between informatica and datastage?
What is the difference between passive stage and active stage?
What is the precedence of stage variables,derivations, and constraints?
Explain ibm infosphere information server and highlight its main features?
How will you move hashed file from one location to another location?
What is a merge in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr