Database Reference
In-Depth Information
Working on partitioning
Before we learn about partitioning, note that partitioning is a high availability feature that
you need to purchase separately from Informatica. If you enable the high availability fea-
ture, you can make use of the partitioning functionality.
By default, a mapping containing the source, target, and transformations has a single parti-
tion. A single partition means a single record can flow from the source to the target at a
time. By adding multiple partitions, you logically divide the mapping into multiple sec-
tions, and each section can pass a record at a time. So, if you make three partitions in the
mapping, three records can pass through the mapping, thus reducing your runtime by one-
third. When you add a partition at any stage of the mapping, Integration Service adds parti-
tions at other stages of the mapping. You need to make sure that you have sufficient
memory space and system capacity to handle the processing of multiple records at a time.
If you have 1000 records to process, and you supposedly created four partitions, Integration
Service will process four records at a time, and the total time required to process 1000 re-
cords will be reduced to a fourth.
To enable partitions, you need to set the partitioning properties in the session task.
