You can configure a session to stream the XML from an Unstructured Data transformation, JMS source, or WebSphere MQ source to the XML Parser transformation. When the PowerCenter Integration Service streams XML data, it splits XML data into multiple segments.

You can configure a smaller input port in the XML Parser transformation and reduce the amount of memory that the XML Parser transformation requires to process large XML files. You can parse XML files that are larger than 100 MB.

When you enable XML streaming, the XML Parser transformation receives data in segments that are less than or equal to the port size. When the XML file is larger than the port size, the PowerCenter Integration Service passes more than one row to the XML Parser transformation. Each XML row has a row type of streaming. The last row has a row type of insert.

The input port precision must be equal to or greater than the output port precision of the object that passes the XML to the XML Parser transformation. When most of the XML documents are small, but some messages are large, set the XML Parser transformation port size to the size of the smaller messages for best performance.

If you enable XML streaming, you must also enable XML streaming for the source or transformation that is passing the XML data to the XML Parser transformation. If you do not enable streaming, the XML Parser receives the XML in one row, which might slow performance.

To enable XML streaming in the XML Parser transformation, select Enable XML Input Streaming in the XML Parser transformation session properties. If you enable XML streaming in the source or transformation, but you do not enable it for the XML Parser transformation, the XML Parser transformation cannot process the XML file.

When you enable XML streaming and an error occurs in the XML document, the PowerCenter Integration Service writes the XML document to the session log by default. You can configure the session to write the XML document to the error log file when an error occurs.

Enable Log Source Row Data in the session properties. When you enable logging, and an error occurs in the XML document, the PowerCenter Integration Service generates a row error. The PowerCenter Integration Service writes the XML document to the error log file and it increments the error count.

For information about XML sizing in PowerCenter, see Using XML with PowerCenter Overview. For more information about the limitations that apply to XML handling in PowerCenter, see Limitations.

To create a transformation with other element types, and to transform larger XML input files, use a Data Processor transformation. For more information about how to create Data Processor transformations, see the

Informatica Data Transformation User Guide

and the

Informatica Data Transformation Getting Started Guide

.