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 XPath Query Predicates

Using XPath Query Predicates

Use a query in an XML view to filter XML source data. The Integration Service extracts data from a source XML file based on the query. If the query is true, the Integration Service extracts data for the view.
To create a query in an XML view, you create an XPath query predicate in the XML Editor. XPath is a language that describes a way to locate items in an XML document. XPath uses an addressing syntax based on the path through the XML hierarchy from a root component. You can create an XPath query predicate for elements in the view row or elements and attributes that have an XPath that includes the view row.
An XPath query predicate includes an element or attribute to extract, and the query predicate that determines the criteria. You can verify the value of an element or attribute, or you can verify that an element or attribute exists in the source XML data.

0 COMMENTS

We’d like to hear from you!