Forum Discussion
alondon
1 year agoFrequent Visitor
Pipeline - Slow copy task
Hello - I'm running a copy task to pull in the last year of data from one table that exists in a DB2 on premise database. The connection is on ODBC. It's been processing now for about 6 hours with...
nilendraFabric
1 year agoSuper User
Hello alondon
Use dynamic range partitioning with degree of parallelism adjusted to your DB2 capacity (start with 8-16 parallel copies).
https://learn.microsoft.com/en-us/fabric/data-factory/copy-performance-sql-databases