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

Using the XML Source Qualifier in a Mapping

Using the XML Source Qualifier in a Mapping

Each group in an XML source definition is analogous to a relational table, and the Designer treats each group within the XML Source Qualifier transformation as a separate source of data.
The Designer enforces concatenation rules when you connect objects in a mapping. Therefore, you need to organize the groups in the XML source definition so that each group contains all the information you require in one pipeline branch.
Consider the following rules when you connect an XML Source Qualifier transformation in a mapping:
  • You can link ports from one group in an XML Source Qualifier transformation to ports in one input group of another transformation.
    You can
    copy
    the columns of several groups to one transformation, but you can
    link
    the ports of only one group to the corresponding ports in the transformation.
  • You can link ports from one group in an XML Source Qualifier transformation to ports in more than one transformation.
    Each group in an XML Source Qualifier transformation can be a source of data for more than one pipeline branch. Data can pass from one group to several different transformations.
  • You can link multiple groups from one XML Source Qualifier transformation to different input groups in a transformation.
    You can link multiple groups from an XML Source Qualifier transformation to different input groups in most multiple input group transformations, such as a Joiner or Custom transformations. However, you can link multiple groups from one XML Source Qualifier transformation to one Joiner transformation if the Joiner has sorted input. To connect two XML Source Qualifier transformation groups to a Joiner transformation with unsorted input, you must create two instances of the same XML source.

0 COMMENTS

We’d like to hear from you!