I need one suggestion,
In my flow service, there is a requirement for selectSQL adater service.
Which connection type should I use:
NO_Transaction
Local_Transaction
go with “NO_Transaction”
if u have any concerns let me know…
Thanks for your help. Actually I asked this question since this was very old service and now there is some requirement in which we need to change the some parameters of the adapter service. While looking at the connection it was earlier build over LOCAL_TRANSACTION and also there were no start and commit transaction statement in the service. ie Now I wanted to change the connection to NO_TRANSACTION as there is only one adapter selectSQL adapter service.
You can go with with either NO TRANS or LOCAL TRANS. As Select is a DDL statement and no modifications happens in db tables, transaction type doesn’t matter in your case.
-Senthil