Secondary Staging at Database and Table Levels | Example | Teradata Data Mover - Example: Specifying Secondary Staging Databases at Database and Table Levels - 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, for table test1 the staging table is created in staging database staging4, and the work, log, and error tables are created in staging database staging1.
<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_for_table><name>staging4</name></staging_database_for_table>
	</table>
</database>