1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

How to convert table data into xml file using xml output
stage? please explain step by step;

Question Posted / srinivas

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


Please Help Members By Posting Answers For Below Questions

What is ds designer?

649

If you want to use a same piece of code in different jobs, how will you achieve this?

782

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1922

What is the difference between informatica and datastage?

650

Nls stands for what in datastage?

725




Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1116

Enlist various types of routines in datastage.

639

What is orabulk stage?

624

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

958

How can you write parallel routines in datastage PX?

612

How do you import and export the datastage jobs?

730

What is apt_config in datastage?

700

sed,awk,head

962

What are stage variables, derivations and constants?

666

Differentiate between hash file and sequential file?

574