You can edit the data type for a Teradata table column prior to importing data in the Smart Load Wizard.
- In Type select the data type for the column you are editing. For a description of data types listed, see Smart Load Type Options.
- 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.
- Select the Values must be unique check box if the data in the column must be unique values. This action deselects Can contain nulls.
- 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.
- Click OK.