Database Reference
In-Depth Information
Partitioning properties
To enable partitioning, you need to define the following attributes.
Partition points
You can define the partition points in a pipeline. By default, Integration Service sets the
partition at various transformations. You can define the partition at any stage in the map-
ping.
The 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, Integration Service adds the same number of parti-
tions at other stages of the mapping. The number of partitions in a mapping should be equal
to the number of database connections on the source and target side. When you create parti-
tions, Integration Service processes the data concurrently. Suppose you created three parti-
tions, then Integration Service reads three records from the source, passes three records to
transformations, and concurrently loads three records to target.
Partition types
Informatica supports multiple types of partitions to distribute the data. The partition type
controls how you wish to divide the data among the partitions you created in the mapping.
If you have the high availability feature available, you can define the type of partition at
different stages of the mapping. You can define the type of partitioning in session proper-
ties. The different types of partitions are mentioned as follows:
Pass-through : In the pass-through type, Integration Service does not distribute the
data among partitions. The data in the particular partition stays in the partition after
passing through the partition point.
Round-robin : In round-robin partitioning, Integration Service distributes the data
evenly among the partitions. This makes an equal amount of data to pass through
each partition.
Key range : In key range partitioning, Integration Service distributes the data on
the basis of ports, sets, or defined ports. You also define the range of values for
each port. When the source and target are partitioned by the key range, select this
type of partitioning.
Search WWH ::




Custom Search