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

Creating Metadata from Relational Definitions

Creating Metadata from Relational Definitions

You can create an XML definition by selecting multiple relational definitions and creating relationships between them. The Designer creates an XML view for each relational definition you import. The Designer converts every column in the relational definition and generates primary key-foreign key relationships. You can choose to create a root view.
The following figure shows a sample XML target definition from the relational definitions, Orders and Order_Items:
The root is XRoot. XRoot encloses Orders and Order Items. Order_Items has a foreign key that points to Orders.

0 COMMENTS

We’d like to hear from you!