MY output file <?xml version="1.0" encoding="UTF-8&quo

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

Question Posted / muktimca

2 Answers
19003 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / muktimca

MY output file

<?xml version="1.0" encoding="UTF-8"?>

<defns:Provisioning
xmlns:defns="urn:ford/Application/ImportAuthorization/v1.0"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<defns:Entity>

<defns:EntityName>

PUB

</defns:EntityName>

<defns:EntityType>

BF

</defns:EntityType>

<defns:User>

<defns:UserName>

D-KUCINA

</defns:UserName>

<defns:Role>

<defns:RoleName>

COVISINT

</defns:RoleName>

<defns:AttributeFunction>

<defns:AttributeType>

COMPOSITE

</defns:AttributeType>

<defns:Attribute>

<defns:ChangeType>

ADD

</defns:ChangeType>

<defns:Name>

SITE

</defns:Name>

<defns:DataSource>

IAR

</defns:DataSource>

<defns:Action>

READ

</defns:Action>

<defns:Value>

U6XTA

</defns:Value>

</defns:Attribute>

</defns:AttributeFunction>

</defns:Role>

</defns:User>

</defns:Entity>

<defns:Entity>

<defns:EntityName>

PUB

</defns:EntityName>

<defns:EntityType>

BF

</defns:EntityType>

<defns:User>

<defns:UserName>

KDUTTON

</defns:UserName>

<defns:Role>

<defns:RoleName>

COVISINT

</defns:RoleName>

<defns:AttributeFunction>

<defns:AttributeType>

COMPOSITE

</defns:AttributeType>

<defns:Attribute>

<defns:ChangeType>

ADD

</defns:ChangeType>

<defns:Name>

TOKEN

</defns:Name>

<defns:DataSource>

IAR

</defns:DataSource>

<defns:Action>

READ

</defns:Action>

<defns:Value>

WQRFQ

</defns:Value>

</defns:Attribute>

</defns:AttributeFunction>

</defns:Role>

</defns:User>

</defns:Entity>

<defns:Entity>

<defns:EntityName>

PUB

</defns:EntityName>

<defns:EntityType>

BF

</defns:EntityType>

<defns:User>

<defns:UserName>

L-LOZEN

</defns:UserName>

<defns:Role>

<defns:RoleName>

COVISINT

</defns:RoleName>

<defns:AttributeFunction>

<defns:AttributeType>

COMPOSITE

</defns:AttributeType>

<defns:Attribute>

<defns:ChangeType>

ADD

</defns:ChangeType>

<defns:Name>

SITE

</defns:Name>

<defns:DataSource>

IAR

</defns:DataSource>

<defns:Action>

READ

</defns:Action>

<defns:Value>

P879Y

</defns:Value>

</defns:Attribute>

</defns:AttributeFunction>

</defns:Role>

</defns:User>

</defns:Entity>

</defns:Provisioning>

<?xml version="1.0" encoding="UTF-8" ?>
- <ie:Provisioning
xmlns:ie="urn:ford/Application/ImportAuthorization/v1.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="urn:ford/Application/ImportAuthorization
/v1.0 ImportAuthorizationR3.xsd">
- <ie:Entity>
<ie:EntityName>PUB</ie:EntityName>
<ie:EntityType>BF</ie:EntityType>
- <ie:User>
<ie:UserName>vbeeram1</ie:UserName>
- <ie:Role>
<ie:RoleName>sta-engineer</ie:RoleName>
- <ie:AttributeFunction>
<ie:AttributeType>BASE</ie:AttributeType>
- <ie:Attribute>
<ie:ChangeType>ADD</ie:ChangeType>
<ie:Name>MY</ie:Name>
<ie:DataSource>GSDBDatabase</ie:DataSource>
<ie:Action>READ</ie:Action>
<ie:Value>2011</ie:Value>
<ie:Value>2012</ie:Value>
<ie:Value>2013</ie:Value>
</ie:Attribute>
- <ie:Attribute>
<ie:ChangeType>DELETE</ie:ChangeType>
<ie:Name>VL</ie:Name>
<ie:DataSource>GSDBDatabase</ie:DataSource>
<ie:Action>READ</ie:Action>
<ie:Value>2011</ie:Value>
<ie:Value>2012</ie:Value>
<ie:Value>2013</ie:Value>
</ie:Attribute>
</ie:AttributeFunction>
- <ie:AttributeFunction>
<ie:AttributeType>FILTER</ie:AttributeType>
- <ie:Attribute>
<ie:ChangeType>ADD</ie:ChangeType>
<ie:Name>BuyerFilter</ie:Name>
<ie:DataSource>simngDS</ie:DataSource>
<ie:Action>READ</ie:Action>
<ie:Value>P01</ie:Value>
<ie:Value>P02</ie:Value>
</ie:Attribute>
</ie:AttributeFunction>
</ie:Role>
</ie:User>
- <ie:User>
<ie:UserName>sstiles4</ie:UserName>
- <ie:Role>
<ie:RoleName>sta-engineer</ie:RoleName>
- <ie:AttributeFunction>
<ie:AttributeType>BASE</ie:AttributeType>
- <ie:Attribute>
<ie:ChangeType>DELETE</ie:ChangeType>
<ie:Name>VL</ie:Name>
<ie:DataSource>GSDBDatabase</ie:DataSource>
<ie:Action>WRITE</ie:Action>
<ie:Value>2011</ie:Value>
<ie:Value>2013</ie:Value>
</ie:Attribute>
</ie:AttributeFunction>
- <ie:AttributeFunction>
<ie:AttributeType>COMPOSITE</ie:AttributeType>
- <ie:Attribute>
<ie:ChangeType>ADD</ie:ChangeType>
<ie:Name>Team</ie:Name>
<ie:DataSource>simngDS</ie:DataSource>
<ie:Action>READ</ie:Action>
<ie:Value>Team1</ie:Value>
<ie:Value>Team2</ie:Value>
</ie:Attribute>
</ie:AttributeFunction>
</ie:Role>
</ie:User>
</ie:Entity>
</ie:Provisioning>

please find .xsd file below

<?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

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between operational data stage (ods) and data warehouse?

666

What are the repository tables in datastage?

817

How many Key we can define in remove duplicate stage?

816

how do u catch bad rows from OCI stage? And what CLI stands for?

2278

Describe routines in datastage? Enlist various types of routines.

577

What is the project in datastage?

660

What are stage variables, derivations and constants?

666

Enlist various types of routines in datastage.

639

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3257

Have you used Unstructured data?

826

What are data elements?

651

Difference between in process and inter process?

689

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1713

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

2983

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

1778