Table of Contents


  1. Preface
  2. Introduction to Data Transformation
  3. Data Processor Transformation
  4. Wizard Input and Output Formats
  5. Relational Input and Output
  6. Using the IntelliScript Editor
  7. XMap
  8. Libraries
  9. Schema Object
  10. Command Line Interface
  11. Scripts
  12. Parsers
  13. Script Ports
  14. Document Processors
  15. Formats
  16. Data Holders
  17. Anchors
  18. Transformers
  19. Actions
  20. Serializers
  21. Mappers
  22. Locators, Keys, and Indexing
  23. Streamers
  24. Validators, Notifications, and Failure Handling
  25. Validation Rules
  26. Custom Script Components

XML Output Schema Example

XML Output Schema Example

The XML Output schema for the XMap example has the following structure:
<?xml version="1.0" encoding="UTF-8"?> <!-- edited with XMLSpy v2012 sp1 (x64) ( by Informatica Corporation (Informatica Corporation) --> <xs:schema xmlns:xs="" xmlns="organization" targetNamespace="organization" elementFormDefault="qualified" attributeFormDefault="unqualified"> <xs:element name="Worker" type="WorkerType"/> <xs:element name="Output"> <xs:complexType> <xs:sequence> <xs:element ref="Organization" maxOccurs="unbounded"/> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Organization"> <xs:complexType> <xs:sequence> <xs:choice maxOccurs="unbounded"> <xs:element name="Worker" type="WorkerType"/> <xs:element name="Manager" type="WorkerType"/> </xs:choice> <xs:element name="Department" type="xs:string" maxOccurs="unbounded"/> </xs:sequence> <xs:attribute name="noOfEmployees" type="xs:int"/> </xs:complexType> </xs:element> <xs:complexType name="WorkerType"> <xs:sequence> <xs:element name="FirstName" type="xs:string" minOccurs="0"/> <xs:element name="LastName" type="xs:string" minOccurs="0"/> <xs:element name="FullName" type="xs:string" minOccurs="0"/> <xs:element name="Id" type="xs:string"/> <xs:element name="YearsOfService" type="xs:int" minOccurs="0"/> </xs:sequence> </xs:complexType> </xs:schema>
The schema root is Output. Output has multiple-occurring Organizations. Within each Organization are Workers and Managers. Workers and Managers are WorkerTypes. A Worker and a Manager contain the same elements. The WorkerType includes a YearsOfService element that the XMap calculates based on the StartDate.

Updated February 12, 2020