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

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
kmo1482331935137.ditamap
dita:ditavalPath
ft:empty
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>