Physical Modeling › Teradata Physical Property Editors › Define Teradata Profiles

Previous Topic: Define Teradata Permissions

Next Topic: Specify and Order the Account IDs in a Teradata Profile

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 New icon in property editors to create a new object 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:
  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