Table of Contents

Search

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

Data Transformation User Guide

Data Transformation User Guide

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) (http://www.altova.com) by Informatica Corporation (Informatica Corporation) --> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" 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 September 26, 2018