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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Published
October 2021
Language
English (United States)
Last Update
2021-10-14
dita:mapPath
cai1626458602965.ditamap
dita:ditavalPath
cai1626458602965.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.