Partitions
If you have the Partitioning license, you can use multiple partitions in a mapping to improve performance for Mapping Configuration tasks. When partitioning is enabled, the Mapping Configuration task creates multiple connections to the source data and processes partitions of the data in parallel.
You can set up partitioning when you configure Source transformations in a mapping. You can choose one of the following partitioning methods:
- •Specify a key range. You can use this method for a mapping with a relational source. The Mapping Configuration task distributes rows of data based on a field that you define as a partition key. For each partition, you define a range of values for the partition key.
- •Specify the number of partitions. Use this method for a mapping with a flat file source. You can specify up to 64 partitions.