Force a Target Staging Table | Teradata Data Mover - 17.11 - About Force Target Staging Table - 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)
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 under 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 above 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>