Source Staging Database Name Table Level | Example | Teradata Data Mover - Example: Specifying Source Staging Database Name at Table Level Only - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.20
Published
November 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
wph1512683331242.ditamap
dita:ditavalPath
4101_UG_dm_1620.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
In this example, the staging database name is specified only at the database level. This results in both tables use staging_db_one as their staging database.
<database selection="unselected">
	<name>MyDB</name>
	<source_staging_database>
	<name>staging_db_one</name>
	</source_staging_database >
	<table selection="included">
		<name>f_table1</name>
		<use_source_staging_table>TRUE</use_source_staging_table>
	</table>
	<table selection="included">
		<name>f_table2</name>
		<use_source_staging_table>TRUE</use_source_staging_table>
	</table>
</database>