DIM Classes
The Global Unique Identifiers for the DIM Class Descriptions and Relationship Descriptions are defined in the header file dbaim.h. This file also contains the constants for the DIM Property Names and Relative Property IDs.
A Teradata Database system is initially loaded into the MDS repository using the metaload program. Meta data objects loaded into the DIM are referred to as DIM objects and are readable by any MDS User with the appropriate read permission.
The information needed to read the values of the properties of objects in the DIM classes is contained in the following tables.
Class Name |
Description |
BusinessAttribute |
A Business Attribute is a characteristic of a Business Entity. This commonly represents a logical column. |
BusinessEntity |
A Business Entity represents a set of objects that have common characteristics. This commonly represents a logical table. |
BusinessRule |
A Business Rule defines any restrictions on what values can be stored in a column. |
Check |
A check constraint on a Teradata table |
Class Function |
A Teradata built-in function or a User Defined Function |
Column |
A column of a Teradata table |
Constant |
A constant value |
Database |
Teradata Database |
DatabaseSystem |
Identifies a Teradata Database System. |
FKReference |
A derived class to track foreign key reference information |
Function |
A Teradata built-in function or a User-Defined Function |
FunctionParameter |
A parameter of a UDF |
FunctionTable |
Defines the table returned by a table function |
HashIndex |
A Teradata hash index |
Index |
An index of a Teradata table |
IndexColumn |
A column of an index |
JoinIndex |
A Teradata join index |
Macro |
A Teradata macro |
MacroParameter |
A parameter of a Teradata macro |
MetaLoadType |
Defines the types of data (tables, views, and so on) to be loaded and tracked in the repository |
Node |
A node of a Teradata system |
Partitioning |
Defines the partitioning of the primary index for a table or join index |
Reference |
A reference constraint on a Teradata table |
ReferenceColumn |
A column of a reference constraint |
SecurityConstraint |
A Teradata row-level security constraint |
SecurityConstraintValues |
The values assigned to security constraints |
SPParameter |
The parameter of a Teradata stored procedure |
StoredProcedure |
A Teradata stored procedure |
SubjectArea |
A subject area is a set of data organized to reflect a specific area of business |
Table |
Teradata table |
Trigger |
A Teradata trigger |
UDT |
A user-defined type |
UDTAttribute |
An attribute of a UDT |
UDTCast |
Defines the cast functions for a UDT that are used by Teradata to convert data between the UDT and other data types |
ValidValue |
The Valid Value defines the possible values associated with a Business Rule |
View |
A Teradata view |
ViewColumn |
A column of a Teradata view |