Creating Models › Target Servers for Physical Models › Database Property Editors › Teradata Physical Property Editors › Define Teradata Profiles

Define Teradata Profiles

You can use the Teradata Profile Editor to create a new profile that defines system parameters that a group of users can share in a Teradata physical model.

To define a Teradata profile

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

   The Teradata Profile Editor opens.

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

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

   Name

   Specifies the name of the profile.

   Default Database

   Specifies the Teradata database that this profile belongs to.

   Generate

   Generates DDL for this object during Forward Engineering.

3. Complete the following fields on the General tab:

   Spool

   Specifies the number of bytes for the spool files.

   Temporary

   Specifies the number of storage bytes allocated for temporary tables.

   Cost profile

   Specifies the cost profile.

   Note: This property does not apply to Teradata 2.6.

4. Work with the other tabs in the editor to access additional design features, for example:
   • Specify and order the account names for a selected profile on the Accounts tab.
   • Specify password options for a selected profile on the Password tab.
5. (Optional) Click the Comment tab and enter any comments you want associated with the profile.
6. (Optional) Click the UDP tab to work with user-defined properties for the profile.
7. (Optional) Click the Notes tab to view history information and view or edit user notes.
8. Click Close.

   The Teradata Profile Editor closes.

More information:

Specify and Order the Account IDs in a Teradata Profile

Specify Password Options of a Teradata Profile

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor