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>

What are the components of datastage?

863

---

What are the important features of datastage?

834

---

What is the difference between the local container and shared container?

855

---

Highlight the main features of datastage?

829

---

How the ipc stage work?

884

---

What are some different alternative commands associated with "dsjob"?

881

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1222

---

What are the repository tables in datastage?

1050

---

Why we use surrogate key?

924

---

What is ds designer?

850

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3435

---

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?

807

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2474

---

how to add a new records into source?

1735

---

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

929

---