Defining Aster Tables - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.12
Published
August 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
pts1468860020550.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
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.