Secondary Staging and General Staging | Example | Teradata Data Mover - 17.10 - Example: Specifying a Secondary Staging Database at Database Level and General Staging Database at Table Level - 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, for table test1 the staging table is created in staging database staging2, and the work, log, and error tables are created in staging database staging3.
<database selection="unselected">
	<name>database1</name>
	<staging_database><name>staging1</name></staging_database>
	<staging_database_for_table><name>staging2</name></staging_database_for_table>
	<table selection="included">
		<name>test1</name>
		<staging_database><name>staging3</name></staging_database>
	</table>
</database>