Specifying Target 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 specify a target staging database name in the create or copy XML file, at the database level or the table level. A separate database for staging tables, macros, work tables, error tables, and log tables is useful if, for example, there is not enough space on the database where the target tables are located. This feature is optional and valid when using Teradata ARC, Teradata PT API, or Teradata JDBC.

All target staging tables, macros, work tables, error tables, and log tables are created based on the database specification.
Database Specification Result
Not provided at the table or database level Are created in the target database of the target tables.
Provided at the database level Are created under the specified target staging database on the target system, unless overridden at the table level.
Provided at the table level Are created under the specified target staging database on the target system, even if a different target staging database name is provided at the database level.