Domain & Completeness tab - Reference Table
Use this tab to compare the data values in a column to a reference table.
- Table Type
- Select the type of reference table that you want to use.
- Table Name
- Select the reference table that you want to use.
- Table Definition
- Shows the description of the selected reference table.
- Reviewed
- Select to specify that the analysis results have been reviewed.
- Rebuild Inferences
- After you mark invalid values in the Domain & Completeness tab, select Valid Values to rebuild column analysis inferences using only the valid values in the column.
Frequency Distribution table
Shows details for all of the data values in the selected column. Specify whether a data value is valid, invalid, or incomplete.
- Outliers
- Shows the number of maximum and minimum values that appear in the frequency distribution table. For example, the default value of 10 specifies that the 10 maximum values and the 10 minimum values display in the frequency distribution table.
- Data Value
- Shows the actual data value from the source.
- Count
- Shows the number of instances of this data value in the column.
- Percent
- Shows the percent of the total records this data value represents.
- Status
- Double-click to specify whether the data value is valid, invalid, or incomplete. By default, the status for each data value is set to valid during the first column analysis job.
- Min/Max
- You can indicate if each row is valid/invalid, minimum or maximum. This field appears only if the domain type is selected as Range and allows you to change the status of the values.
- Show Quintiles
- Click to view all of the data values in the column divided into five graphic subsets.
- Drill Down
- Click to view the detailed information of all instances of the data value in the selected value.
- Delete
- Click to remove the selected data value from the frequency distribution. You can delete a data value that has a frequency count of 0.
- New Value
- Click to add a new data value to the frequency distribution. You might want to add a data value to the frequency distribution if a known data value does not occur in the data source but you want to include that value in a reference table.
Completeness Summary
Shows an overview of the count and percentage of complete and incomplete data values in the selected column. This object list also provides details for each data value that has been marked incomplete.
- Distinct Values
- Shows a count of the distinct data values that are marked as complete and incomplete and the percent that those values represent in the total count of distinct values in the column.
- Records
- Shows a count of the total data values that are marked as complete and incomplete and the percent that those values represent in the total count of data values in the column.
- Incomplete Values table
- Data Value
- Shows the actual data value from the source.
- Count
- Shows the number of instances of this data value in the column.
- Percent
- Shows the percent of the total records this data value represents.
Validity Summary
Shows an overview of the count and percentage of valid and invalid data values in the selected column. Additionally, this object list provides details for each data value that has been marked invalid.
- Distinct Values
- Shows a count of the distinct data values that are marked as valid and invalid and the percent that those data values represent in the total count of distinct data values in the column.
- Records
- Shows a count of the total data values that are marked as valid and invalid and the percent that those data values represent in the total count of data values in the column.
- Invalid Values table
- Data Value
- Shows the actual data value from the source.
- Count
- Shows the number of instances of this data value in the column.
- Percent
- Shows the percent of the total records this data value represents.