Physical Modeling › Teradata Physical Property Editors › Specify Teradata Domains in a Physical Model

Specify Teradata Domains in a Physical Model

You can use the Domain Dictionary dialog to modify and order the domains for a Teradata physical model.

To specify Teradata domains in a physical model

1. Click Domain Dictionary on the Model menu.

   The Domain Dictionary dialog opens.

2. Select Physical from the Edit Mode list and choose the Sort method.

   Note: The Edit Mode option only appears if you are in a Logical/Physical model.

   The domains appear in the order you selected.

3. Select the domain you want to modify from the Domain list. When you select a domain from the list, the domain properties specified for the selected domain appear in the dialog tabs. You can change the properties of multiple domains in one session without closing the Domain Dictionary dialog. Any changes you make to a domain are implemented in the model when you click OK or select a different domain name from the Domain list.

   New

   Opens the New Domain dialog where you can add a domain.

   Rename

   Opens the Rename Domain dialog where you can edit the name of the selected user-defined domain. You cannot change the standard domain names. If you rename the Physical name, but not the Logical name, you break the link between the logical and physical model. An asterisk next to the Physical field indicates that the property value is derived from domain inheritance or a macro.

   Delete

   Deletes the selected domain from the model.

   Reset

   Opens the Reset Domain Properties dialog where you can reset one or more domain properties to the domain's default setting. For example, if you change the null option setting for a new domain from NULL (a value inherited from the parent domain) to NOT NULL, you can use the Reset Domain Properties dialog to reset the default NULL setting.

4. Complete the following fields on the General tab:

   Domain Parent

   Defines the parent of the selected domain. To change the parent, select a different domain from the list. This is a non-inheritable property.

   Generate As Udd

   Generates the selected domain as a user-defined datatype in the schema. If you clear this check box, the datatype of the domain is used when it includes column information in the CREATE TABLE statement.

   Name Inherited by Column

   Defines the name or macro that the column inherits when associated with the selected domain. The macro %AttDomain automatically migrates the logical domain name to the column name.

   Physical Only

   Select this check box if you want the selected domain to be available in the physical model only. Clear this check box if you want the selected domain to be available in both the physical and logical model.

   Macro Toolbox

   Opens the Macro Toolbox where you can select a macro. Note that macros applied in the Domain Dictionary Dialog override those applied in the Name Mapping tab of the Model Naming Options dialog.

5. Work with other tabs in the editor to access additional design features, for example:
   • Specify transform options on the Teradata tab
   • Specify ordering options on the ...Teradata tab
   • Assign default or validation constraints on the Constraint tab.
6. (Optional) Click the Comment tab and enter any comments you want associated with the domain.
7. (Optional) Click the UDP tab to work with user-defined properties for the domain.
8. Click OK.

   The Domain Dictionary editor closes.

More information:

Specify Options for a Teradata Domain

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

Specify a Validation Rule and Default Value for a Domain

Specify a Data Source For a Domain