You can edit the data type for an Aster table column prior to importing data in the Smart Load Wizard.
- In Type select the Aster data type for the column you are editing. For a list of data types supported in Smart Load Wizard, see Aster Data Types.
- 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.
- Select the Distribute by Hash check box if you want to specify a distribution key column. Using DISTRIBUTE BY HASH with a distribution key is mandatory for fact tables and optional for dimension tables. You must select at least one column in the table to distribute by hash.
- Click OK.