Performance Limitation | Teradata Data Mover - Performance Limitation - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-26
dita:mapPath
tsn1650877444606.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

DSA Incremental Copy is not the same as change data capture (CDC) because DSA is a block copying utility.

During DELTA executions, DSA copies change data blocks from source to target. Hence, even when the rate of data change is small during DELTA copy, the expected performance gain may not be observed from FULL copy, if changed rows affects a large number of underlying data blocks.