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

Generating Entity Relationships

Generating Entity Relationships

You can generate an XML hierarchy as an entity relationship model. When you generate XML view entity relationships, the Designer completes the following actions:
  • Generates views for multiple-occurring and referenced elements and complex types.
  • Creates relationships between the views.
When the Designer generates entity relationships, the Designer generates different entities for complex types, global elements, and multiple-occurring elements based on the relationships in the schema.
If you want to create groups other than the default groups, or if you want to combine elements from different complex types, you can create custom XML views.
When you view an XML source definition in the XML Editor, you can see the relationships between each element in the XML hierarchy. For each relationship between views, the XML Editor generates links based on the type of relationship between the views.
To generate entity relationships:
  1. In the Source Analyzer, click Sources > Import XML Definition.
    The XML Wizard opens.
  2. Navigate to the source you want to import and click Open.
  3. Enter a name for the file and click Next.
  4. Select Entity Relationships and click Finish.
    The XML Wizard generates an XML definition that uses entity relationships.

0 COMMENTS

We’d like to hear from you!