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 an XML Source Qualifier Transformation Manually

Creating an XML Source Qualifier Transformation Manually

You can create an XML Source Qualifier transformation in a mapping if you have a mapping that contains XML source definitions without Source Qualifiers or if you delete the XML Source Qualifier transformation from a mapping.
To create an XML Source Qualifier transformation manually:
  1. In the Mapping Designer, create a new mapping or open an existing one.
    There must be at least one XML source definition without a source qualifier in the mapping.
  2. Click Transformation > Create.
    The Create Transformation dialog box appears.
  3. Select XML Source Qualifier transformation, and type a name for the transformation.
    The naming convention for XML Source Qualifier transformations is XSQ_
    TransformationName
    .
  4. Click Create.
    The Designer lists all the XML source definitions in the mapping with no corresponding XML Source Qualifier transformations.
  5. Select a source definition and click OK.
    The Designer creates an XML Source Qualifier transformation in the mapping and links each port of the XML source definition to a port in the XML Source Qualifier transformation.

0 COMMENTS

We’d like to hear from you!