16.00 - Defining Aster Tables - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
When creating tables in Aster Database, follow these guidelines:
  • Each table must be either a fact table or a dimension table.
  • Because Aster Database physically distributes most tables, the rows of each distributed table are stored throughout the cluster. The Distribute By field in the Storage tab of the Table object form enables you to control distribution of data by specifying a distribution key.
  • Optionally you can partition data in a large table into child partitions. Partitioning can enable faster query responses. The Partition by field in the Storage tab of the Table form enables you to control how data is partitioned.

For more information about table types in Aster Database, see the Aster Database User Guide.