Java data types
You can map the native data types to Java data types. When you map the native data type, select the best Java data type to read from the data source and select the best native data type to write to the target database or application.
Multiple native metadata objects
You can define multiple native metadata definitions for an adapter. For example, you can create different native metadata objects for tables, views, and synonyms in a relational data source.
Sort and select
You can define Sort statement support for an adapter to retrieve data from the data source in a specific order. You can define whether the adapter supports Select statement when the adapter reads from the data source. You can use the Informatica Connector Toolkit to define the following Select statements for an adapter:
Select First Row
Select Last Row
You can specify the partition type and implement the partition logic to use when the adapter reads or writes data.
You can specify one of the following partition types or all the partition types for an adapter:
Dynamic. The Data Integration Service determines the number of partitions at run time based on the partition information from the data source.
Static. The Data Integration Service determines partitioning logic based on the partition information that the user specifies, such as the number of partitions or key range partitioning.
You can specify whether the read and write capability attributes of a native metadata object support full parameterization or partial parameterization. The read and write capability attributes of the native metadata object can be assigned values or parameters at run time.
Pre and Post data operation
You can implement pre and post tasks that can be run before or after a read or write operation. For example, you can implement the functionality to truncate a target table before a write operation.
You can create messages to handle exceptions that occur during the design time or run time of the adapter. You can use the Message wizard to add, edit, or delete messages. You can localize the message files if required.
C run time
You can implement the run-time behavior of the adapter in C. You can write code to define how the adapter reads from and writes to the data source in C.
You can implement support for reject files to handle data rejected by the target.