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

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2171

---

Differentiate between odbc and drs stage?

1046

---

How do you reject records in a transformer?

1118

---

What is the precedence of stage variables,derivations, and constraints?

1074

---

What are transforms and what is the differenece between routines and transforms?

1056

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1032

---

CHANGE CAPTURE

1298

---

What all the types of jobs you developed?

1175

---

Demonstrate experience in maintaining quality process standards?

2542

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2166

---

in oracle target stage when we use load option and when we use upsert option?

2274

---

how can we create rank using datastage?what is the meaning of rank?

8781

---

Give an idea of system variables.

1018

---

How many Key we can define in remove duplicate stage?

1372

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2240

---