If you import an XML file that has components defined with infinite lengths, you can easily exceed the 500 MB limit for total column length. You can change the column lengths in the XML Editor, or you can set an option to override all infinite lengths and reimport the file.

The DTD or XML schema file that you can view is a temporary file that the Designer creates for viewing. If you want to use the file for other purposes, save the file with another name and directory when you view it.

When you add columns to XML source views, you do not add elements to the underlying hierarchy. The XML hierarchy that you import remains the same no matter how you create the views or how you map the columns in a view to the elements in the hierarchy. You can modify the datatypes and the cardinality of the elements, but you cannot modify the structure of the hierarchy.

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

.