Creating Models › Creating a Physical Model › Tables › Table Editor › Define Teradata Table Properties

Define Teradata Table Properties

Use the Teradata Table Editor to define table properties. This procedure assumes you are working in a physical model, with Teradata defined as the target server.

To define properties for a Teradata table

1. Click Tables on the Model menu.

   The Teradata Table Editor opens.

2. Select the table in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new table. Use the Enter filter text box to filter a very large list of tables to quickly locate the one that you want to define.

   Physical Name

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

   Database

   Specifies the database to which the table belongs. Change the database of the table in this field.

   Teradata Type

   Specifies the type of Teradata table. Select the type of table that you want to create.

   Physical Only

   Specifies whether the table is suppressed from a logical model and appears in a physical model only.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

   Temporal Type

   Specifies the type of temporal table.

3. Click the General tab and set the required properties out of the following:

   Checksum

   Specifies a table-specific disk I/O integrity checksum level.

   Data Block Size Type

   Specifies the type of the data block size of the table.

   Data Block Size

   Specifies the data block size for the table. Set the value according to the selected Data Block Size Type.

   Fallback Protection

   Specifies whether the table uses Fallback Protection. Adding fallback creates and stores a duplicate copy of the table.

   Free Space

   Specifies the percent of free space (within the allowable range of 0 to 75 percent) that will remain on a cylinder during loading operations.

   Logging

   Specifies whether online archive logging for the table should be done.

   Row Control

   Specifies duplicate row control type.

   Commit Type

   Specifies the action to be performed on the contents of an instance when a transaction completes.

   Replication Group

   Specifies the name of the replication group to which this table is to be added if it matches a rule set up by a CREATE REPLICATION RULESET request. You can either select an existing replication group or create a new one.

   Has No Primary Index

   Specifies whether the table has a primary index.

   Partitioning Expression

   Specifies the expression used for partitioning for the table.

   Block Compression

   Specifies whether the data in the table should be block-compressed.

   Merge Block Ratio Type

   Specifies the way to combine existing small data blocks into a single larger data block during full table modification operations for permanent tables and permanent journal tables.

   Merge Block Ratio

   Specifies the Merge Block Ratio value. Set the value depending on the selected Merge Block Ratio Type.

   Load Isolation

   Specifies the technique used for concurrent read operations on committed rows while the table is being loaded.

   System-Versioned

   Specifies the type of temporal table.

4. Click the Volumetrics tab and work with the following options:

   Initial Row Count

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

   Max Rows

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

   Growth By Month

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

5. Work with the other tabs in the editor to access additional design features, for example:
   • Specify validation rules in the Validation tab.
   • Preview the forward engineering script for a table in the SQL tab.
   • Work with style sheets to format the font used in the display of the table in the Style tab.
   • Specify the icon style to use for the table in the Icon tab.
   • Specify the order of DDL generation in the Object Creation Order tab.
6. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
7. (Optional) Click the Where Used tab to view where the object is used within the model.
8. (Optional) Click the UDP tab to work with user-defined properties for the object.
9. (Optional) Click the History tab to view the history information for the object.
10. (Optional) Click the Notes tab to view and edit user notes.
11. Click Close.

    The table is defined and the Teradata Table Editor closes.

For more information on table properties, refer to Teradata Database documentation.