Specifying Source Staging at the Database and Table Levels - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
kmo1482331935137.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

You can use ARC to specify a source staging database to partially move a non-PPI table or a view. This allows you to move a non-PPI table or view to a source staging table, then from the source staging table to the target system. To use a specified source staging table, you must set use_source_staging_table to true at the object level in the create XML file.

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.