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 a Type Relationship

Creating a Type Relationship

You can create a type relationship between a column in a view and a type view. If the column is pivoted, you can choose occurrences to include in the relationship.
To create a type relationship:
  1. Right-click the column in the view you want to use.
  2. Select Create Relationship.
  3. If the column is pivoted, select an occurrence to use.
  4. Move the pointer to the type 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.
  5. If no error message appears, click the parent view to establish the relationship.
    The XML Editor creates the relationship.

0 COMMENTS

We’d like to hear from you!