Editing Teradata Column Data Types - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
bpb1467322243715.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
You can edit the data type for a Teradata table column prior to importing data in the Smart Load Wizard.

  1. In Type select the data type for the column you are editing. For a description of data types listed, see Smart Load Type Options.
  2. Select the Can contain nulls check box if the data in the column can include null values. This action de-selects the Values must be unique check box if it is selected.
  3. Select the Values must be unique check box if the data in the column must be unique values. This action deselects Can contain nulls.
  4. If you selected SMALLINT as the data type, you can select the Distribute by Hash check box if you want specify a distribution key column. Using DISTRIBUTE BY HASH with a distribution key is mandatory for fact tables and optional for dimension tables. Joins involving columns that are part of a distribution key constraint will be optimized.
  5. Click OK.