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?

Answers were Sorted based on User's Feedback



How to work with XML out put stage? Please explain step by step? i need to generate XML file using..

Answer / 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

How to work with XML out put stage? Please explain step by step? i need to generate XML file using..

Answer / muktimca

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"

targetNamespace="urn:ford/Application/ImportAuthorization/v1
.0"
xmlns:ie="urn:ford/Application/ImportAuthorization/v1.0"
elementFormDefault="qualified"
attributeFormDefault="unqualified">

<xs:element name="Provisioning"
type="ie:ProvisioningType" />


<xs:complexType name="ProvisioningType">
<xs:annotation>
<xs:documentation>
Root node where “Provisioning” is the name
of the app team.
</xs:documentation>
</xs:annotation>
<xs:sequence>
<xs:element name="Entity"
type="ie:EntityObjectType"
minOccurs="1" maxOccurs="1" />
</xs:sequence>

</xs:complexType>


<xs:complexType name="EntityObjectType">
<xs:annotation>
<xs:documentation>
Type of entity either application or
business function.
</xs:documentation>
</xs:annotation>
<xs:sequence>

<xs:element name="EntityName" type="xs:string"
minOccurs="1"
maxOccurs="1" />
<xs:element name="EntityType"
type="ie:EntityTypeType" minOccurs="1"
maxOccurs="1" />
<xs:element name="User" type="ie:UserType"
minOccurs="1"
maxOccurs="unbounded" />
</xs:sequence>

</xs:complexType>


<xs:complexType name="UserType">

<xs:annotation>
<xs:documentation>
User Node, contains 1..n roles for a
user .
</xs:documentation>
</xs:annotation>

<xs:sequence>

<xs:element name="UserName" type="xs:string"
minOccurs="1" maxOccurs="1" />
<xs:element name="Role" type="ie:RoleType"
minOccurs="1" maxOccurs="unbounded"/>
</xs:sequence>

</xs:complexType>


<xs:complexType name="RoleType">

<xs:annotation>
<xs:documentation>
Role Node, contains all info for a
role
</xs:documentation>
</xs:annotation>
<xs:sequence>
<xs:element name="RoleName" type="xs:string"
minOccurs="1"
maxOccurs="1" />
<xs:element name="AttributeFunction"
type="ie:AttributeObjectType" minOccurs="1"
maxOccurs="unbounded" />

</xs:sequence>

</xs:complexType>

<xs:complexType name="AttributeObjectType">

<xs:annotation>
<xs:documentation>
AttributeObject, contains all info for a
role
</xs:documentation>
</xs:annotation>
<xs:sequence>
<xs:element name="AttributeType"
type="ie:AttributeObjectTypeType" minOccurs="1"
maxOccurs="1" />
<xs:element name="Attribute"
type="ie:AttributeTypeType" minOccurs="1"
maxOccurs="unbounded" />

</xs:sequence>

</xs:complexType>


<xs:complexType name="AttributeTypeType">
<xs:annotation>
<xs:documentation>
Attribute Node, contains all info for an
attribute.
</xs:documentation>
</xs:annotation>
<xs:sequence>
<xs:element name="ChangeType"
type="ie:ChangeTypeType" minOccurs="1"
maxOccurs="1" />
<xs:element name="Name" type="xs:string"
minOccurs="1" maxOccurs="1"/>
<xs:element name="DataSource" type="xs:string"
minOccurs="1" maxOccurs="1"/>
<xs:element name="Action" type="ie:ActionType"
minOccurs="1" maxOccurs="1"/>
<xs:element name="Value" type="xs:string"
minOccurs="1" maxOccurs="unbounded"/>
</xs:sequence>


</xs:complexType>

<xs:simpleType name="AttributeObjectTypeType">
<xs:restriction base="xs:string">
<xs:enumeration value="BASE" />
<xs:enumeration value="FILTER" />
<xs:enumeration value="COMPOSITE" />
</xs:restriction>
</xs:simpleType>
<xs:simpleType name="EntityTypeType">
<xs:restriction base="xs:string">
<xs:enumeration value="BF" />
<xs:enumeration value="APP" />
</xs:restriction>
</xs:simpleType>

<xs:simpleType name="ActionType">
<xs:restriction base="xs:string">
<xs:enumeration value="READ" />
<xs:enumeration value="WRITE" />
</xs:restriction>
</xs:simpleType>


<xs:simpleType name="ChangeTypeType">
<xs:restriction base="xs:string">
<xs:enumeration value="ADD" />
<xs:enumeration value="DELETE" />
</xs:restriction>
</xs:simpleType>

</xs:schema>

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Data Stage Interview Questions

How do u call shellscript/Batch file from DS?

4 Answers   HP,


guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers   TCS,


what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers   TCS,


DataStage Scenario based Interview Questions

1 Answers  


How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,


What is datastage engine?

0 Answers  


how to delete one row in target dataset

0 Answers   Satyam,


What is APT_DUMP_SCORE?

2 Answers   IBM,


how to handle null values in sequential file?

1 Answers   HCL,


Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  


1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,


What are the features of datastage flow designer?

0 Answers  


Categories