Target Staging at Database and Table Levels | Example | Teradata Data Mover - Example: Specifying Target Staging at the Database and Table Levels - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem
In this example, the f_table1 table uses the staging_db_two database. The staging_db_one database specified at the database level is overridden. The f_table2 table uses the staging_db_one database that is specified 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>DBName</name>
	<staging_database>
		<name>staging_db_one</name>
	</staging_database>
	<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>