Example 2: Specifying Target Staging at Database Level Only - Teradata Data Mover

In this example, the f_table1 table uses staging_db_two as its staging database. However, for the f_table2 table, a staging database name is not specified at the table level. Therefore, the table uses the target table database, MyDB, as the staging database. Data Mover supports using either the staging_database or target_staging_database tags to specify the target staging database, but not both at the same time.

<database selection="unselected">
	<name>MyDB</name>
	<table selection="included">
		<name>f_table1</name>
		<staging_database>
			<name>staging_db_two</name>
		</staging_database>
	</table>
	<table selection="included">
		<name>f_table2</name>
	</table>
</database>