You can increase the number of partitions in a pipeline to improve session performance. When you increase the number of partitions, the PowerCenter Integration Service can create multiple connections to sources and process partitions of sources and target data concurrently.
Use the following rules and guidelines when you configure partitioning for WebSphere MQ sessions:
Performance improvement.
Performance does not scale beyond 3 partitions.
Associated source qualifier.
You can specify multiple partitions if there is no associated source qualifier in the pipeline.
MQ Source Qualifier.
You can only specify the pass-through partition type when you create partition points.
WebSphere MQ targets.
You can specify pass-through, key range, hash keys, and round-robin partition types when you create partition points. You cannot merge output files from sessions with multiple partitions if you use a WebSphere MQ message queue as the target connection type.
Real-time sessions.
The PowerCenter Integration Service may not read messages in the same order as they exist in the source. If you require the delivery of messages in sequence, do not create multiple partitions.