You can use the Informatica Connector Toolkit to configure static partitioning if you require the user to specify the partition information before the adapter reads data.
When you define a native metadata object, you can implement static partitioning for read capabilities of the native metadata object. Based on the data source, you can implement following static partitioning types:
- 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.
You can implement static partitioning only for adapters with read capability.