Table of Contents

Search

  1. Preface
  2. XML Concepts
  3. Using XML with PowerCenter
  4. Working with XML Sources
  5. Using the XML Editor
  6. Working with XML Targets
  7. XML Source Qualifier Transformation
  8. Midstream XML Transformations
  9. Appendix A: XML Datatype Reference
  10. Appendix B: XPath Query Functions Reference

XML Guide

XML Guide

Working with XML Sources Overview

Working with XML Sources Overview

The Designer provides an XML Wizard that you can use to create XML definitions in the repository. You can import files from a URL or local node to create an XML definition. You can also import relational or flat file definitions from a PowerCenter repository. You can create XML definitions from the following file types:
  • XML files
  • XML schema files
  • DTD files
  • Relational definitions
  • Flat file definitions
When you create XML definitions, you import files with the XML Wizard and organize metadata into XML views. XML views are groups of columns containing the elements and attributes in the XML file. The wizard can generate views for you, or you can create custom views.
You can create relationships between views in the XML Wizard. You can create hierarchy relationships or entity relationships.
You can synchronize an XML definition against an XML schema file if the structure of the schema changes.

0 COMMENTS

We’d like to hear from you!