Certain rules and guidelines apply to XML files that you include in table pairs and single-table constraints.
Use the following rules and guidelines for XML files:
Data Validation Option ignores content in a CDATA section of an XML file.
Data Validation Option cannot process complex XML files, such as those that require the Unstructured Data transformation in a PowerCenter mapping.
The XML files must conform to the PowerCenter rules and guidelines for XML sources and targets.
You might encounter memory and row-size errors when you run a test on an XML file that contains columns with unlimited lengths. To resolve the errors, re-create the XML file definition in PowerCenter to override all infinite lengths with a value. Next, refresh the latest XML file definition in Data Validation Option.
For more information about PowerCenter rules and guidelines for XML sources and targets, see the