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.05
Published
October 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
xxl1591023586203.ditamap
dita:ditavalPath
mpm1591127278842.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>