Copy Columns | Teradata Data Mover - About Copying Columns - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.00
Published
November 30, 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
gmn1574692806523.ditamap
dita:ditavalPath
cjo1509024828169.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
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 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.