To view column properties, in Repository, select a column name, then choose View details. For a selected column, Column displays Attributes and Discretes.
Attributes 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 Class Code column in the Household table.
Figure 4‑4 Exploring properties of a permanent column
Discretes displays a value for each of 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 Class Code column in the Household table.
Figure 4‑5 Exploring discrete values of a permanent column