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. XML Datatype Reference
  10. XPath Query Functions Reference

XML Guide

XML Guide

Creating a Relationship Between Views

Creating a Relationship Between Views

Use the XML Editor to create hierarchical or inheritance relationships between views. You cannot create a relationship between an XML source and a non-XML source.
To create a relationship between XML views:
  1. Right-click the top of the child XML view in the workspace.
  2. Select Create Relationship.
  3. Move the pointer to the parent view to establish a relationship.
    As you move the pointer, a link appears between the views, and the XML Editor verifies that the relationship is valid. If a relationship is not valid, an error message appears in the status bar.
  4. If no error message appears, click the parent view to establish the relationship.
    The XML Editor creates the relationship and adds the appropriate foreign key.
  5. To view details about the relationship, place the cursor over the link between the views.
    The Editor displays the relationship type and the primary and foreign keys.

0 COMMENTS

We’d like to hear from you!