Answer:   We have 3 types of JDBC Adapter Transactions.
1)NO_TRANSACTION:The connection automatically commits the
operations.
2)LOCAL_TRANSACTION:The connection uses local transactions. If we plan to use the connection with BatchInsertSQL or
BatchUpdateSQl adapter services,we must specify LOCAL_TRANSACTIONS types.
If we are configuring a BasicNotification and using theexactly once notification and delete stored records options
we must configure the notification to use LOCAL_TRANSACTION type.
3)XA_TRANSACTION:The connection uses XA transactions.
When we are connecting to Teradata we use XA transaction.