Learning Informatica PowerCenter 10.x - Second Edition

Number of partitions

Based on your system capability, you can increase or decrease the partitions. When you add a partition at any stage of the pipeline, the integration service adds the same number of partitions at other stages of the mapping. The number of partitions in a mapping should be equal to the number of database connections at the source and target side. When you create partitions, the integration service processes the data concurrently. Suppose you create three partitions; the integration service reads three records from the source, passes three records to transformations, and concurrently loads three records to the target.