Specify Target Staging at Database and Table Levels | Teradata Data Mover - 17.10 - Specifying Target Staging at the Database and Table Levels - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)

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.