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.