About Copying Columns

Teradata Data Mover User Guide

brand
Analytical Ecosystem
prodname
Teradata Data Mover
vrm_release
16.10
category
User Guide
featnum
B035-4101-067K
You can copy a column using the Data Mover command-line interface by specifying the value table_columns when a table is selected.
<database selection="unselected">
	<name>dmguest</name>
	<table selection="included">
		<name>table1</name>
  <target_name>NewTable1</target_name>
     <table_columns>
         <name>column1</name>
         <target_name>targetColumn1</target_name>
         <type>varchar</type>
         <target_type>string</target_type>
     </table_columns>
	</table>
</database>

Column settings can be modified when moving tables between Teradata and Hadoop or Teradata and Aster systems. If a target column is not specified, the source column name is used as the target. If the source column name is not valid on the target system, the column must be renamed to a valid value.