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

Midstream XML Generator Tab

Midstream XML Generator Tab

Use the XML Generator tab to modify the size of the DataOutput port. You can also add pass-through ports on this tab.
You can access the XML Editor from the Midstream XML Generator Tab. Click the XML Editor button. When you access the XML Editor, you cannot edit transformation properties until you exit the XML Editor.
The following table describes the options you can change on the XML Generator transformation tab:
Transformation Setting
Description
Precision
Length of the column. Default DataOutput port precision is 64K. Default precision for a pass-though port is 20. You can increase the precision.
On Commit
The Integration Service can generate multiple XML documents after a commit. Use one of the following options:
  • Ignore Commit. The Integration Service creates the XML document and writes data to the document at end of file. Use this option if two different sources are connected to the XML Generator transformation.
  • Create New Document. Creates a new XML document at each commit. Use this option if you are running a real-time session.
When a session uses multiple partitions, the Integration Service generates a separate XML document for each partition, regardless of On Commit settings. If you select Create New Document, the Integration Service creates new documents for each partition.
Description
Describes the transformation.
The Designer sets the transformation scope to all input when you set the On Commit setting to Ignore Commit. The Designer sets the transformation scope to the transaction level if you set On Commit to Create New Doc.

0 COMMENTS

We’d like to hear from you!