Specify Target Staging at Database Level | Example | Teradata Data Mover - 17.11 - Example: Specifying Target Staging at Database Level Only - 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)
In this example, the f_table1 table uses staging_db_two as its staging database. However, for the f_table2 table, a staging database name is not specified at the table level. Therefore, the table uses the target table database, MyDB, as the staging 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.
<database selection="unselected">
	<name>MyDB</name>
	<table selection="included">
		<name>f_table1</name>
		<staging_database>
			<name>staging_db_two</name>
		</staging_database>
	</table>
	<table selection="included">
		<name>f_table2</name>
	</table>
</database>