Force a Target Staging Table | Teradata Data Mover - About Force Target Staging Table - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.00
Published
November 30, 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
gmn1574692806523.ditamap
dita:ditavalPath
cjo1509024828169.ditaval
dita:id
B035-4101
lifecycle
previous
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 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>