Specify Job Creation XML at Job Level | Teradata Data Mover - Job Level Specification Using Job Creation XML - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.20
Published
November 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
wph1512683331242.ditamap
dita:ditavalPath
4101_UG_dm_1620.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
Job Creation XML supports the following tags 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.

When these values are specified, they are applied to all the table objects included in the job request. For non-table or view objects, if these values are supported, they need to be specified at the object level. These tags are optional, and must be positioned after the <force_utility> tag.

<overwrite_existing_objects>true</overwrite_existing_objects>
<force_utility>tptapi</force_utility>
<source_staging_database><name>stagingsourceDB</name></source_staging_database>
<target_staging_database><name>stagingtargetDB</name></target_staging_database>
<staging_database_for_table><name>stagingDBForTable</name></staging_database_for_table>
<target_database><name>targetDB</name></target_database>
...