You can leave the start and end range blank for a partition. When you leave the start range blank, the Integration Service uses the minimum data value as the start range. When you leave the end range blank, the Integration Service uses the maximum data value as the end range.

Specify the key range for the partitions in a continuous sequence.

When you enable key range partitioning for a mapping that runs in the native environment, change the

Maximum Parallelism

attribute in the Data Integration Service properties from the default value to an appropriate value, as required. Else, the mapping fails with a java.lang.Exception error.