Staging and Target Systems at Job and System Levels | Teradata Data Mover - Specifying Staging and Target at the Job and System Levels - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem

During job creation, the following tags are supported at the job level:

  • source_staging_database
  • target_staging_database or staging_database
  • staging_database_for_table
  • target_database

Data Mover supports using either the staging_database or target_staging_database tags to specify the target staging database, but not both at the same time.

Specified values are applied to all the table objects included in the job request. These tags are optional and must be positioned after the force_utility tag.

<force_utility>tptapi</force_utility>
<source_staging_database><name>stagingDB</name></source_staging_database>
<!--target_staging_database><name>stagingDB</name></target_staging_database-->
<staging_database><name>stagingDB</name></staging_database>
<staging_database_for_table><name>stagingDBForTable</name></staging_database_for_table>