Physical Modeling › Teradata Physical Property Editors › Specify Teradata Domains in a Physical Model › Specify Options for a Teradata Domain

Specify Options for a Teradata Domain

You can use the Teradata tab in the Domain Dictionary editor to work with datatype, null, compile, and transform options for a domain in a Teradata physical model.

To specify options for a Teradata domain

1. Click Domain Dictionary on the Model menu.

   The Domain Dictionary dialog opens.

2. Work with the following fields on the Teradata tab:

   Teradata Datatype

   Displays the datatype of the selected domain. You can select another datatype from the drop-down list. If the datatype supports a value for average width or Percent NULL you can indicate the value in the appropriate box.

   Null Option

   Specifies the NOT NULL clause for the selected column.

   Compile

   Specifies the mode that the domain should be compiled in. Select from the drop-down list. Valid values are: Compile and Build or Compile Only.

   Transform

   Group Name

   Specifies the transform group name.

   From Type

   Specifies how the transform is being performed. Select from the drop-down list. Valid values are: Specific Method, Instance Method, Specific Function or Function.

   Procedure

   Specifies the user defined type associated with the function/method used for the transform.

   To Type

   Specifies how the transform is being performed. Select from the drop-down list. Valid values are: Specific Function or Function.

   Procedure

   Specifies the function/method used for the transform.

   Generate

   Specifies whether the transform is generated in a forward engineering operation.

   Note: Additional domain options are provided on the second ...Teradata tab in the Domain editor.

3. Click Close.

   The Domain Dictionary editor closes.

More information:

Specify the Ordering Options for a Teradata Domain in a Physical Model