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

Troubleshooting Working with the XML Editor

Troubleshooting Working with the XML Editor

When I validate an XML definition, I get an error that says the XML definition is too large. Why does this occur?
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.
I cannot find the DTD or XML schema file that I created when I viewed XML metadata.
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 I add columns to XML source views, the hierarchy in the source XML file remains the same.
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
.

0 COMMENTS

We’d like to hear from you!