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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.05
Published
October 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
xxl1591023586203.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
In this example, table f_table1 uses the staging_db_two database. The database specified at the database level, staging_db_one, is overridden. The table f_table2 uses the staging_db_one database that is specified at the database level.
<database selection="unselected">
	<name>DBName</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>
		<source_staging_database>
			<name>staging_db_two</name>
		</source_staging_database>
	</table>
	<table selection="included">
		<name>f_table2</name>
		<use_source_staging_table>TRUE</use_source_staging_table>
	</table>
</database>