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 Parser Tab

Midstream XML Parser Tab

Use the Midstream XML Parser tab to modify the size of the DataInput port. You can also add pass-through ports on this tab.
You can access the XML Editor from the Midstream XML Parser Tab. Click the XML Editor button.
When you access the XML Editor, you cannot update Edit Transformations until you exit the XML Editor.
The following table describes the options you can change on the Midstream XML Parser tab:
Transformation
Description
Precision
Length of the column. Default DataInput port precision is 64K. Default precision for a pass-though port is 20. You can increase the precision.
Restart
Always start the generated key sequence at 1. Each time you run a session, the key sequence values in all groups of the XML definition start over at 1.
Reset
At the end of a session, reset the value sequence for all generated keys in all groups. Reset the sequence numbers back to where they were before the session.
Route Invalid Payload Through Data Flow
Validate the XML against a schema. If the XML is not valid for the schema, a row error occurs. The XML Parser transformation returns the XML and associated error messages to a separate output group.
Description
Describes the transformation.
If you do not select Reset or Restart, the sequence numbers in the generated keys increase from session to session. If you select the Restart or Reset option, you update the Restart or Reset property that appears on the Initialization Properties tab. You cannot change these options from the Initialization Properties tab, however.

0 COMMENTS

We’d like to hear from you!