XML Guide

10.4.0
- 10.5

Back Next

Troubleshooting Midstream XML Transformations

I need to extract XML files from a database table that contains an XML CLOB. Each XML file can be up to 2 GB. If I create an XML Parser transformation, I need to define a fixed maximum length for the CLOB column. However, the maximum length for the CLOB datatype is 104 MB.

The XML data is too large to pass directly from the table to an XML Parser transformation. You need to stage the CLOB table data to a flat file and create an XML source definition from the file.

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

Midstream XML Transformations

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal