Table Columns/ Discovery-Specific Statistic | Description |
In Relationship | Indicates if this column is involved in a Discovery relationship. Click Display Results to see the relationships of each type in the Result tab. |
Relationships | The number of relationships in which this column is involved. <#>—The number of relationships for this column. Click Display Results to see details about the relationships in the Result tab. |
Key Type | If this column is a primary or foreign key, displays the key type: PK— Primary key. FK— Foreign key. |
Null Permitted? | Y if nulls are permitted; blank if nulls are not permitted. |
% Null | The percentage of null values in this column. |
Total Null | The total number of rows that have a null in this column. <#>—The number of nulls in this column. Click Display Results to see the data in this table in the Result tab. |
Total Non Null | The total number of rows that have a value in this column. <#>—The number of rows that have a value in this column. Click Display Results to see the data in this table on the Result tab. |
Unique Constraint? | Y if the values in this column must be unique; N if not. |
% Unique | The percentage of unique values in this column. |
Total Unique | The total number of rows that have unique values in this column. <#>—The number of rows that have unique values in this column. Click Display Results to see the rows with unique data on the Result tab. |
Total Non Unique | The total number of rows that have non unique values in this column. <#>—The number of rows that have non unique values in this column. Click Display Results to see the rows with non unique data in the Result tab. |
Distinct | The total number of rows that have distinct values in this column. <#>—The number of rows that have distinct values in this column. Click Display Results to see the rows with distinct values in the Result tab. |
Min | The minimum value in this column. If numeric, the lowest numeric value. If alphabetic, the value that begins with the lowest letter in the alphabet where A is low and Z is high. |
Max | The maximum value in this column. If numeric, the highest numeric value. If alphabetic, the value that begins with the highest letter in the alphabet where A is low and Z is high. |
Mode | Which term happens most frequently. |
% Mode | The percentage of time the mode occurs. |
Denormalize | The separator to use for denormalization. Typically, a comma, period, space (\s), or tab (\t). |