The PowerCenter XML file must only contain one workflow.

The workflow must contain one Session task with one mapping.

The workflow cannot include task types other than Session tasks.

Do not edit the XML file after you've exported the workflow from PowerCenter. Instead, change the workflow in PowerCenter and then export it again.

The session can contain up to 64 partitions for sources and targets.

The session can use pre-session and post-session commands.

The session must have the Enable High Precision session property enabled.

The mapping must contain a source definition and target definition.

The mapping cannot contain an IIF expression with values of different data types, such as the following IIF expressions:

[IIF(ANNUALREVENUE >0,NAME)]
[IIF(emplid_offset = 'Y',LINE_NO + 1,LINE_NO]

The mapping cannot include reusable objects such as reusable transformations or shortcuts because

Data Integration

doesn't use a repository like PowerCenter does, so reusable objects cannot be stored.