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

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

2043

How to perform incremental load in datastage?

1125

What is a ds designer?

1024

explain about citrix scheduling tool in datastage

2379

how to export or import the jobs in .ISX file

1132

What is the difference between odbc and drs stage?

1042

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2756

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

2382

What is the use of datastage director?

972

In Datastage, how you can fix the truncated data error?

1095

Why do you need stage variables?

1131

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?

992

What is "fatal error/rdbms code 3996" error?

1189

What is the flow of loading data into fact & dimensional tables?

1012

What is the importance of the exception activity in datastage?

1014