Hi @suvbin
Batch Apply is the default setting because it is much faster than Transactional Apply.
Transactional Apply mode is generally slower than Batch apply mode because the task will replay the source TLog transactions exactly as they are ordered in the source TLog. Each update to a record will be applied to the target one statement at a time.
Batch Apply mode will do many optimizations to the transactions that it reads from the source Tlog. A couple of examples would be the combining of several statements on one table into a single statement. Like the Insert followed by a couple of update statements would be combined into a single Insert Statement, or several Update statements that would be combined. The most import thing that batch will do is apply all the records in the bac=tch as a single command to the target instead of hundreds, if not thousands of individual statements.
In general batch apply should be used since it is faster.
In some task environments like a Bi Directional task pair it is required to use transactional mode.
Le me know if this helps out and or please accept this as a solution
Thanks,
Michael Litz
