In a model based on a Teradata target server, you use the Teradata tab in the Domain Editor to manage the data type, null option, and other properties for the selected domain.
Note: The options described here are the basic options available for most physical data types. There can be more options available depending on the physical data type you assign to the domain. We recommend that you see the Teradata documentation for more information about using these properties.
To specify Teradata domains in a physical model
The Domain Editor opens.
Lists the physical domain name.
Defines the parent of the selected domain. To change the parent, select a different domain from the list. This is a non-inheritable property.
Indicates the physical data type for the selected domain.
Indicates that the selected domain will be generated as a user-defined domain. Select the check box to enable this option.
Specifies that the selected domain is only available in the physical model. Select the check box to enable this option. Clear the check box if you want the selected domain to be available in both the physical and logical model.
Displays the data type of the selected domain. You can select another data type from the drop-down list. If the data type supports a value for average width or Percent NULL you can indicate the value in the appropriate box. You can choose to inherit or override the physical data type.
Specifies the usage of the NULL clause for the selected column. You can choose to inherit or override the null option.
Specifies the average width for the column domain, if the option is available (not dimmed). For example, for a variable width string data type, you can assign an average width of 20 characters as the average character width of any column that uses the domain. You can later use the Volumetrics dialog to calculate table and database size estimates based on columns that use the domain. You can choose to inherit or override the average width.
Defines the estimated percentage of null values used for the column domain, if the option is available (not dimmed). For example, for a variable width string data type, you can assign an estimate of 30 to indicate that any column using the column domain will contain a null about 30 percent of the time. Use whole numbers. You can later use the Volumetrics dialog to calculate table and database size estimates based on these and other values. You can choose to inherit or override the percent null value.
Specifies the Teradata display format to use for the domain. Select the display format from the drop-down list or open the Teradata Display Format Editor to work with display formats. You can choose to inherit or override the selected display format.
Lets you enter a name (up to 60 characters) that identifies the column values in Teradata applications. You can choose to inherit or override the selected title.
Specifies the mode in which the domain should be compiled. Select from the drop-down list. Valid values are: Compile and Build, or Compile Only.
Specifies to apply column compression. When you select the check box, you can click the New button on the Compress Values toolbar to enter a compress value.
Specifies the type of ordering procedure. Select from the drop-down list. Valid values are: Specific Method, Instance Method, Specific Function, or Function.
Specifies the reference ID of the function or method that is used to order on.
Specifies whether this ordering is generated in a forward engineering operation.
Specifies the transform group name.
Specifies how the transform is being performed. Select from the drop-down list. Valid values are: Specific Method, Instance Method, Specific Function, or Function.
Specifies the user defined type associated with the function/method used for the transform.
Specifies how the transform is being performed. Select from the drop-down list. Valid values are: Specific Function or Function.
Specifies the function/method used for the transform. If none display, click the New icon to open the Function Editor.
Specifies whether the transform is generated in a forward engineering operation.
Specifies the type of character set to use.
Note: This option is only available if you select a character data type, such as CHAR, CHAR VARYING(), CHAR(), and so on.
Specifies how Teradata considers the case of the values stored in database fields for columns during processing. For example, table, TABLE, and Table are treated as different values when this option is specified. You can select either None, Case-Specific, or Not Case-Specific.
Note: This option is only available if you select a character data type, such as CHAR, CHAR VARYING(), CHAR(), and so on.
Specifies whether column values are stored exactly as entered or automatically converted to uppercase characters. Select the check box to store values in uppercase. Clear the check box to store values exactly as it is entered.
Note: This option is only available if you select a character data type, such as CHAR, CHAR VARYING(), CHAR(), and so on.
The Teradata Domain Editor closes.
|
Copyright © 2017 erwin Inc.
All rights reserved.
|
|