Narrow when serial source access is used

Both when we determine a transaction is needed and how the processing is performed under a transaction can be improved. We we likely need to reintroduce a property on the translator to tell the engine when the source is XA, local transaction, etc.