General and Secondary Staging | Example | Teradata Data Mover - Example: Specifying General and Secondary Staging Databases at Database and Table Levels - Teradata Data Mover

Teradata® Data Mover User Guide - 20.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
Product Category
Analytical Ecosystem
In this example, for table test1 the staging table is created in staging database staging4, 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>
		<staging_database_for_table><name>staging4</name></staging_database_for_table>
	</table>
</database>