Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 8199 Views
- TCS, I also Faced
- E-Mail Answers
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
What are the types of hashed files in data stage
What is the project in datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the types of containers?
What are the main differences you have observed between 7.x and 8.x version of datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
CHANGE CAPTURE
What is difference between symmetric multiprocessing and massive parallel processing?
how many rows sorted in sort stage by default in server jobs
Can you implement SCD2 using join, transformer and funnel stage?
What is usage analysis in datastage?
On which interface you will be working as a developer?
what is the use of skid in reporting?
