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

Setting XML View Options

Setting XML View Options

By default, the Integration Service generates rows for each view that has data in the view row. To change how the Integration Service generates rows for some XML source definition views, select XML View Options in the XML Columns window.
Use the following methods to determine when the Integration Service generates rows from an XML source:
  • Generate all the foreign keys in a view.
    By default, the Integration Service generates values for one foreign key in a view. If a view has more than one foreign key, the other foreign keys have null values. You can generate values for all the foreign keys.
  • Stop recursive reads in a circular relationship
    . By default, the Integration Service generates rows for all occurrences of data in a circular relationship. You can generate a row for just the first occurrence of recursive data.
  • Generate a row for a child view if a parent exists.
    By default, the Integration Service creates rows for all views with data in the view row. You can generate a row for a child view only when a parent view has data.
  • Generate a row for a view without view row data.
    By default, the Integration Service generates data for a view when the view row has data. You can generate a row for a view that has no data in the view row.
  • Generate rows for specific complex types in a type relationship.
    By default, the Integration Service generates rows for all views in the XML definition. You can generate rows for specific views in type relationships.

0 COMMENTS

We’d like to hear from you!