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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)

In this example, table f_table1 uses staging_db_two as its source staging database and table f_table2 does not specify the staging database name at the table level. This results in the table using the source table database, MyDB, as the source staging database.

<database selection="unselected">
	<name>MyDB</name>
	<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>