Pipeline partition in Informatica

Pipeline Partitioning a mapping in Informatica means to partition the pipeline inside the mapping.

A pipeline will contain the source, transformations and targets. Mapping will be subdivided into many pipelines are called stage pipeline.

After enabling partitioning in stage pipeline when we run the integration service it runs faster and we can expect more performance. The integration service will run the partition threads concurrently.

To enable partition

· Set the partition points in the mapping

· Set the number of partitions

· Set the partition types



Partition points marks the boundaries that divide the pipeline into stages. By default Integration Service will keep partition at various transformations. Partition points mark the points in the pipeline where the Integration Service can redistribute data across partitions.

When we give Partition points it actually creates various stage pipelines inside the mapping. Now we need to decide how many partitions we need to have inside one stage pipeline.

When we add more partitions it increases the performance of Informatica. You can define up to 64 partitions at any partition point in a pipeline. Also note that if we define two Partitions at any partition point, then the remaining partition points will also have two partitions.