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

Re-Creating Entity Relationships

Re-Creating Entity Relationships

You can re-create entity relationships for an XML definition. Use the Recreate Entity Relationships dialog box to generate new XML views using the same options as in the XML Wizard. When you regenerate views, you can choose to keep the existing views. The XML definition contains all the views.
To re-create entity relationships for an XML definition:
  1. Open the XML definition in the XML Editor.
  2. Highlight the XML root in the Navigator.
    If you highlight another component, the XML Editor uses that component as the root.
  3. Click XML Views > Create Entity Relationship.
  4. Choose from the following options to reduce metadata explosion:
    • Reduce element explosion
      . For any multiple-occurring or reference element, the XML Wizard creates one XML view with multiple hierarchical relationships.
    • Reduce complex type explosion
      . For any multiple-occurring or referenced complex type, the XML Wizard creates one XML view with multiple type relationships. If the schema uses inherited complex types, you can also reduce explosion of inherited complex types.
    • Reduce complex type inheritance explosion
      . For any inherited type, the XML Wizard creates one XML view using multiple type relationships.
    • Share existing XML views.
      Do not remove existing XML views.
    • Refresh shared XML views.
      Save existing views but update them.
  5. Click Next.
    The Recreate Entity Relationships dialog box appears.
  6. To display a child component, select a shared element or complex type and click the name.
  7. To exclude a child component, clear the element in the Exclude Child Components pane.
    To generate a new view, select the element or complex type. When you create the new entity relationships, you generate a view with that element as a view root.

0 COMMENTS

We’d like to hear from you!