Job Level Specification Using Job Creation XML - 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
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>
...