You can optimize performance by eliminating target bottlenecks. The most common performance bottleneck occurs when the task writes to a target.
Network latency, performance issues with the target instance type used for the database or data warehouse, or problems during heavy loading operations can cause target bottlenecks.
ASK INFAPreview
