Example 3: Specifying Target Staging at Table Level Only - 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
In this example, both tables use staging_db_one as their staging database because the staging database name is specified only at the database level. 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.
<database selection="unselected">
	<name>MyDB</name>
	<staging_database>
		<name>staging_db_one</name>
	</staging_database>
	<table selection="included">
		<name>f_table1</name>
	</table>
	<table selection="included">
		<name>f_table2</name>
	</table>
</database>