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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)

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.