Force a Target Staging Table | Teradata Data Mover - About Force Target Staging Table - 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
Data Mover normally creates staging tables when the target table exists and is not empty during a copy, except when copying a full or partial table in the following circumstances:
  • Using DSA to copy and the target table exists
  • Using TPT, T2T, or JDBC to copy and the target table exists and is empty
When you want Data Mover to create a staging table on the target database for the mentioned scenarios, set force_target_staging_table to true. A staging table is not created when the target table does not already exist on the target system, regardless if force_target_staging_table is set to true.
<table selection="included">
	<name>Table1</name>
	<force_target_staging_table>true</force_target_staging_table>
</table>