Fixed
If you require partition logic based on the partition information specified by the user, implement fixed partitioning capability. For example, if the data source does not provide partition information, you can implement partitioning logic based on the user inputs. The user enters the partition information, such as the number of partitions, before the adapter reads data from the data source.
Key range
If the tables in the data source support key range partitioning, you can add support for key range partitioning capability. Before you add support for key range partitioning, you must ensure that the adapter supports filter operation and platform expression. The Informatica Connector Toolkit implements key range partitioning as a filter query. The adapter user enters the partition keys and key range when the adapter reads data from the data source.