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

Querying Mixed Content

Querying Mixed Content

An XML element has mixed content when it contains a value and it contains child elements. You can create an XPath query predicate to filter element values that are divided by child elements. However, the Integration Service does not evaluate predicates that occur after the first child element in mixed content.
For example, an XML file might contain a NAME element with mixed content:
<NAME>   Kathy     <MIDDLE> Mary </MIDDLE>   Russell </NAME>
Element NAME has the value “Kathy”, a child element “MIDDLE”, and a second value “Russell.” The NAME column value is “KathyRussell.” However, the Integration Service evaluates the NAME “Kathy.”
The following query is false:
EMPLOYEE [./NAME = 'KathyRussell']
The following query is true:
EMPLOYEE [./NAME = 'Kathy']

0 COMMENTS

We’d like to hear from you!