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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)
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>
...