Physical Modeling › Teradata Physical Property Editors › Define Teradata Databases

Define Teradata Databases

You can use the Teradata Database Editor to manage databases so that other database objects can be created and stored in it in a Teradata physical model.

To define a Teradata database

1. Click Target-Teradata, Databases on the Model menu.

   The Teradata Database Editor opens.

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

   Note: Click New on the toolbar to create a new database. Use the Enter filter text text box to filter a very large list of databases to quickly locate the one you want to work with.

   Name

   Specifies the name of the database.

   Account

   Specifies the account to be charged for the space used by this database.

   From Database

   Specifies the schema of the database to which the table belongs. Select from the drop-down list.

   Generate

   Generates DDL for this object during Forward Engineering.

3. Complete the following fields on the General tab:

   Permanent

   Specifies the number of bytes to be reserved for the permanent storage of this database.

   Spool

   Specifies the number of bytes to be allowed for spool and volatile temporary files.

   Temporary

   Defines how many bytes are allowed for creating global temporary tables by users within the database.

   Fallback Protection

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

   Before Journal Image

   Specifies the image type of the before journal image. Select from the drop-down list. Valid values are: None, Single, and Dual.

   After Journal Image

   Specifies the image type of the after journal image. Select from the drop-down list. Valid values are: None, Single, Dual, Local, and Not Local.

   Default Journal

   Specifies the default table that is to receive the journal images of tables created in the database.

4. Click the Permission tab to associate permissions with the selected database. Features on the Permission tab let you to create new permissions, work with existing permissions, and open the Teradata Permissions Editor to define permission options.
5. (Optional) Click the Comment tab and enter any comments you want associated with the database.
6. (Optional) Click the UDP tab to work with user-defined properties for the database.
7. (Optional) Click the Notes tab to view history information and view or edit user notes.
8. Click Close.

   The Teradata Database Editor closes.

More information:

Add Permissions in a Teradata Property Editor

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor

Define Teradata Default Values

You can use the Teradata Default Values Editor to create server default values to associate with columns in a Teradata physical model.

To define Teradata default values

1. Click Default Values on the Model menu.

   The Teradata Default Values Editor opens.

2. Select a default value and work with the following options:

   Note: Click New on the toolbar to create new default values. Use the Enter filter text text box to filter a very large list of default values to quickly locate the one you want to work with.

   Physical Name

   Specifies the name of the default value.

   Value

   Specifies the default value.

   Physical Only

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

3. (Optional) Click the Comment tab and enter any comments you want associated with the default values.
4. (Optional) Click the Where Used tab to view where the default values are used in the model.
5. (Optional) Click the UDP tab to work with user-defined properties for the default values.
6. (Optional) Click the Notes tab to view history information and view or edit user notes.
7. Click Close.

   The Teradata Default Value Editor closes.