To view column properties, in the Repository tree, double-click a column name to open the Column screen where you can view both the Attributes and Discretes for the chosen column.
The Attributes tab in the Column screen displays a value for each of the following column properties:
ID
Internal code that identifies the column
Name
A column name
Full name
Full column name in the following format:
[Database].[Table].[Column]
Type
Type of data (text, integer, and so on)
Discretes
Number of column’s discrete values
Rows
Number of rows in the database
Nulls
Number of column’s null values
Size
Column size
Indexed
Indicates if column is indexed
Derived
Indicates if the column is dynamic or permanent
For example, Figure 4‑4 shows all properties defined for the Occupation Decode column in the Customer table.
Figure 4‑4 Exploring properties of a permanent column
In this case the column is “Not derived” (dynamic - having no data values). Discretes displays values for only the following column properties:
Value
Discrete value of the column
Count
Number of records for which the column has this value
Percentage
Percentile of the count number to the total number of records
For example, Figure 4‑5 shows all discrete values defined for the Occupation Decode column in the Customer table.
ID
