Specify Target Staging at Database Level | Example | Teradata Data Mover - Example: Specifying Target Staging at Database Level Only - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.00
Published
November 30, 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
gmn1574692806523.ditamap
dita:ditavalPath
cjo1509024828169.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
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>