You must set the maximum parallelism based on the number of partitions that you want to add. You can set the parallelism either in the Data Integration Service Properties or in the SAS mapping properties.
To set the maximum parallelism in the Data Integration Service properties, perform the following tasks:
Navigate to the
Execution Options
section in the Administrator tool.
Set the maximum parallelism based on the number of partitions that you want to configure.
The following image shows the maximum parallelism set for the Data Integration Service based on the number of partitions:
Restart the Data Integration Service.
To set the maximum parallelism in the SAS mapping, perform the following tasks:
In the SAS mapping properties, click the
Run-time
tab.
In the
Execution Environment
section on the right-hand side, enter the required maximum parallelism value for the native environment.
The following image shows the maximum parallelism set in the mapping properties: