Partial Copies with Source Staging Table and DSA | Teradata Data Mover - About Performing Partial Copies using Source Staging Table and DSA - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-06-16
dita:mapPath
fcu1619423186706.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
When performing a partial copy of a view or table using a source staging table, add the use_source_staging_table tag to the XML and set the tag to true. This enables Data Mover to use DSA when copying the table or view when DSA is a valid copy method.
<table selection="included">
	<name>f_table1</name>
<use_source_staging_table>TRUE</use_source_staging_table>
</table>

For information on specifying a source staging database, see Specifying Source Staging at the Database and Table Levels.