Copying a View - 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 a view definition and the underlying view data to a table or a view on a target Teradata system.

Views cannot be copied between Teradata and Aster or Hadoop systems.

  1. In the Objects tab, click to expand the tree.
  2. Click to expand a database or user object where the view is located.
  3. To filter so only views display, do the following:
    1. Click and clear all check marks except for View.
    2. Move the cursor off of the object-types filter to refresh the tree with views in the sub-branch.
  4. Click to display the View Settings dialog box. The name of the view displays at the top of the dialog box.
  5. [Optional] Under Copy the following, specify what you want to copy:
    • Only definition
    • Only data to table
    • Both definition and data to table
    • Both definition and data to view
  6. Do one of the following:
    • If you are copying only the definition, skip to step 13 and you are finished.
    • If you are copying data, continue with steps 5 through 12.
  7. [Optional] To perform a partial table copy, enter the predicate of the WHERE restrictive clause in the Include Only Where box. Do not enter the keyword WHERE. For example, if you want to restrict a partial table copy to only the columns in which col1 is greater than 4, type col1 > 4 in the box.
  8. If you are copying only data or both definition and data to a table, enter the target table name in the Target table name box.
  9. If you are copying only data or both definition and data to a table, click next to Map to Different Database on Target, and select a database. You can use the filter to display only the items that match the characters you enter.
  10. [Optional] To use a staging database for tables, click next to Staging database for tables, and select a database. You can use the filter to display only the items that match the characters you enter.
  11. [Optional] To use a separate staging database for temporary artifacts, click next to Staging database for temporary artifacts, and select a database. You can use the filter to display only the items that match the characters you enter.
  12. [Optional] To verify that the number of rows in the source and target tables match after completing the copy job, select one of the following options from the Validate Row Count list.
    Option Description
    None Do not check row count. None is the default setting.
    Partial Perform a row-count check on the subset of data that was copied. Only applies when doing partial table copies.
    All Perform a row-count check on the entire table. Applies to full or partial table copies.
  13. [Optional] To verify that important aspects of the DDL for the source and target tables match before performing the copy, select one of the following options from the Compare DDL list.
    Option Description
    Default By default, Data Mover compares the DDL.
    True Compare the DDL before performing the copy.
    False Do not compare the DDL before performing the copy.
  14. [Optional] For a partial table copy, select one or more key columns from the Key Columns list to specify which columns uniquely identify each row when upserting them into the target table. You must specify at least one key column from the list. You can select multiple columns by holding the Ctrl key and clicking the column names in the list. Specify all primary indexes as key columns if at least one of the primary indexes is unique.
  15. Click OK.