Defining Aster Tables - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
sbq1486739977986.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
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.