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

Product
Teradata Data Mover
Release Number
17.12
Published
January 2022
Language
English (United States)
Last Update
2022-01-18
dita:mapPath
ptl1635805434108.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
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>