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

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 DSA, 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.