You can specify a 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 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 staging database on the target system, unless overridden at the table level. |
| Provided at the table level | Are created under the specified staging database on the target system, even if a different staging database name is provided at the database level. |