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.

what is ds administrator used for?

1164

---

What are some prerequisites for datastage?

1094

---

What are the functionalities of link partitioner?

1014

---

What is the difference between orabulk and bcp stages?

1023

---

What is use Array size in datastage

1775

---

What are the different common services in datastage?

1278

---

What can we do with datastage director?

1232

---

What is the use of datastage director?

1013

---

Difference between in process and inter process?

1224

---

project Steps,hits, Project level HArd things,Solved methods?

2124

---

How to find value from a column in a dataset?

2194

---

Define Data Stage?

1087

---

What is the difference between server job and parallel jobs?

1151

---

What is the project in datastage?

1108

---

Can you explain engine tier in information server?

1128

---