Physical Modeling › Teradata Physical Property Editors › Define Teradata Tables

Define Teradata Tables

You can use the Table editor to create new tables (entities) and to modify properties on existing tables in a Teradata physical model.

To define Teradata tables

1. Click Tables on the Model menu.

   The Table Editor opens.

2. Select a table and work with the following options:

   Note: Click New on the toolbar to create a new table.

   Physical Name

   Specifies the physical name of the table. Change the physical name of the table in this field.

   Database

   Specifies the database or user to which the table belongs. Select the schema from the drop-down.

   Teradata Type

   Specifies the type of the entity. Select from the drop-down. Valid values are: Permanent, Global Temporary, Global Temporary Trace, or Queue Table.

   Physical Only

   Lets you specify whether the table should be suppressed from a logical model and appear in a physical model only.

   Generate

   Generates DDL for this object during Forward Engineering.

3. Complete the following fields on the General tab:

   Checksum

   Defines the level of integrity checking for disk I/O. Select from the drop-down list. Valid values are: All, Default, Low, Medium, High, and None.

   Commit Type

   Specifies what happens to the data in a temporary or volatile table when the transaction completes. Select from the drop-down list. Valid values are: Delete or Preserve.

   Data Block Size

   Specifies the data block size. Data can include Bytes or Kilobytes designation following the value.

   Data Block Size Type

   Specifies the data block size type. Select from the drop-down list. Valid values are: Minimum, Maximum, or Specified.

   Fallback Protection

   Specifies the type of fallback protection for the database. Select from the drop-down.

   Free Space

   Specifies the amount of free space.

   Logging

   Select to specify whether logging of changes to the data occurs.

   Row Control

   Specifies if duplicate rows are allowed in the table. Select from the drop-down list. Valid values are: Set or Multiset.

   Volumetrics

   Grow by

   Specifies growth increments for the table. Enter a value in the field.

   Max Row

   Specifies row sizing for the table. Enter a value in the field.

   Row Count

   Specifies row count for the table. Enter a value in the field.

4. Work with the other tabs in the editor to access additional design features, for example:
   • Specify journal options for a selected table on the Journal tab
   • Define constraints for a selected table on the Validation tab
   • Generate an error table for a selected table on the Error Table tab
   • Associate permissions with the selected table on the Permission tab
   • Change the object creation order on the Object Creation Order tab
   • View the history for a selected table on the History tab
5. (Optional) Click the Comment tab and enter any comments you want associated with the table.
6. (Optional) Click the UDP tab to work with user-defined properties for the table.
7. Click Close.

   The Table Editor closes.

More information:

Define a Dimensional Modeling Role in a Property Editor

Define Data Movement Rules in a Property Editor

Specify Journal Options for a Physical Object

Define Constraints that are Associated with the Table

Specify Error Table Options

Add Permissions in a Teradata Property Editor

Add a Comment in a Property Editor

Change the Object Creation Order in a Property Editor

Add a UDP in a Physical Property Editor

View History in a Property Editor