SAP Connector > Part IV: Data Integration using SAP Table > Mappings and mapping tasks with SAP Table > Key range partitioning for SAP Table sources
  

Key range partitioning for SAP Table sources

You can configure key range partitioning when you use a mapping task to read data from SAP table sources using normal mode. With key range partitioning, the Secure Agent distributes rows of source data based on the fields that you define as partition keys. The Secure Agent compares the field value to the range values for each partition and sends rows to the appropriate partitions.
Use key range partitioning for columns that have an even distribution of data values. Otherwise, the partitions might have unequal size. For example, a column might have 10 rows between key values 1 and 1000 and the column might have 999 rows between key values 1001 and 2000. If the mapping includes multiple sources, use the same number of key ranges for each source.
When you define key range partitioning for a column, the Secure Agent reads the rows that are within the specified partition range. For example, if you configure two partitions for a column with the ranges as 10 through 20 and 30 through 40, the Secure Agent does not read the rows 20 through 30 because these rows are not within the specified partition range.
You can configure a partition key for fields of the following data types:
You cannot use key range partitions when a mapping includes any of the following transformations:

Configuring key range partitioning for SAP Table sources

When you use a mapping task to read data from SAP table sources, you can configure key range partitioning to improve performance. Define the partition keys and key ranges based on which the Secure Agent must distribute rows of source data.
    1. In the source properties, click the Partitions tab.
    2. In the Partition Key field, select the required partition key from the list.
    3. In the Key Ranges section, click Add New Key Range to define the number of partitions and the key ranges based on which the Secure Agent must partition data.
    Use a blank value for the start range to indicate the minimum value. Use a blank value for the end range to indicate the maximum value.

Best practices for key range partitioning

If you increase the partitions in normal mode, tune the value of the parameter rdisp/wp_no_btc on the SAP server accordingly to increase the throughput. The parameter rdisp/wp_no_btc denotes the number of background processes.
Contact your SAP administrator to increase the value of the parameter on the SAP side.