About Copying Tables - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
You can copy an individual table using the Data Mover command-line interface by specifying the value table selection="included" and the name of the table. For example, the XML below will copy table1 and table3 as they specify the value table selection="included". The other table in the object list, table2, will not be copied because the value is set to table selection="unselected".
<database selection="unselected">
	<name>dmguest</name>
	<table selection="included">
		<name>table1</name>
	</table>
	<table selection="unselected">
		<name>table2</name>
	</table>
	<table selection="included">
		<name>table3</name>
 </table>
</database>

Tables can be copied between Teradata systems, as well as between a Teradata system and an Aster or Hadoop system. Aster fact and dimension tables and Hadoop hive tables can be copied.