About Column Specification - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use the Copy Object Wizard to copy Teradata table data to another existing Teradata table. You can select whether a column is copied by selecting a column name and data type for the new destination column. Filters allow you to specify smaller sets of data to copy.

Source Column Name/Type
List of table columns stored in the source database you selected. Select which columns you want copied to the destination table by specifying a name for the an existing column in the destination table.
Destination Column Name/Type list
Select an option each source column to map the source column name and data type to an existing destination column.
Select Source By list
Select a filter type from the list, and if appropriate, enter a filter value in the text box. You must enter a value that is valid for the column data type. The data type displays beside the column name.
Existing Destination Table Data options
Specify how you want data copied to the destination table:
Option Description
Append data to destination table Appends the copied data to the end of existing data in the table.
Replace existing data in destination table Replaces any existing data in the destination table with the copied data.
Copy Data Job Name
Copy Object Wizard generates a default job name based on the source table name. You can edit the default job name.
Reset
Return all values in the screen to their default settings.