Use MERGE to Copy Data | Performance | Teradata Data Mover - About Using the Merge Table Feature - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem

In some circumstances, Data Mover uses MERGE instead of INSERT-SELECT when copying data from a staging database to a target database. The result is better performance.

The following conditions must be met for Data Mover when using MERGE:

  • A partial table copy must be specified.
  • The table cannot be a multiset table.
  • The table must contain one or more primary indexes.
  • All indexes must be specified as key columns.
  • For PPI tables, all partitioned columns must be specified as key columns.
  • The primary index on the target table does not contain an identity column.

If these conditions are not met, Data Mover uses DELETE and INSERT-SELECT to transfer data.

For PPI tables, indexes and partitioned columns must be specified as key columns. Specifying only the indexes as key columns results in a failed job execution.