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 Input Schema Example

XML Input Schema Example

The XML Input 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="company" targetNamespace="company" elementFormDefault="qualified" attributeFormDefault="unqualified"> <xs:element name="Employee" type="EmployeeType"/> <xs:element name="Input"> <xs:complexType> <xs:sequence> <xs:element ref="Company" maxOccurs="unbounded"/> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Company"> <xs:complexType> <xs:sequence> <xs:element name="Name" type="xs:string"/> <xs:element ref="Department" maxOccurs="unbounded"/> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Department"> <xs:complexType> <xs:sequence> <xs:element name="Name" type="xs:string"/> <xs:element ref="Employee" maxOccurs="unbounded"/> </xs:sequence> </xs:complexType> </xs:element> <xs:complexType name="EmployeeType"> <xs:sequence> <xs:element name="FirstName" type="xs:string" minOccurs="0"/> <xs:element name="LastName" type="xs:string" minOccurs="0"/> <xs:element name="Role" type="xs:string" minOccurs="0"/> <xs:element name="StartDate" type="xs:date" minOccurs="0"/> </xs:sequence> <xs:attribute name="id" type="xs:string"/> </xs:complexType> </xs:schema>
The schema root is Input. Input has multiple-occurring Companies. With in each Company are multiple Departments. Each Department has Employees. Employee has a Role that determines whether the employee is a manager or not.

Updated March 18, 2021