Specify Source Staging at Database and Table Levels | Teradata Data Mover - Specifying Source Staging at the Database and Table Levels - 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

You can use DSA to copy partial data from a table or view using a source staging table. Specify where to create the source staging table by specifying a source staging database.

Staging Database Name Staging Database Name Result
Not provided at the table or database level Created in the source database of the source tables.
Provided at the database level Created under the specified staging database on the source system, unless overridden at the table level.
Provided at the table level Are created under the specified staging database on the source system, even if a different staging database name is provided.