XML Guide

10.5
- 10.4.0

Back Next

Limitations

The following limitations apply to XML handling in PowerCenter:

The XML schema must be smaller than 400 elements.

The XML schema file must be smaller than 100 KB.

The XML file size must be 10 MB or smaller.

The complexity profile is limited to three hierarchy levels.

The XML Import Wizard creates a maximum of 400 views.

PowerCenter does not support the following functions:

Concatenated columns.
A column cannot be a concatenation of two elements. For example, you cannot create a column FULLNAME that refers to a concatenation of two elements FIRSTNAME and LASTNAME.

Composite keys.
A key cannot be a concatenation of two elements. For example, you cannot create a key CUSTOMERID that refers to a concatenation of two elements LASTNAME and PHONENUMBER.

Parsed lists.
PowerCenter stores a list type as one string that contains all array elements. PowerCenter does not parse the respective simple types from the string.

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

Using XML with PowerCenter Overview

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal