Analysis settings

The analysis settings provide a parameter-driven control for how certain analysis is to be performed by the system. The system is installed with default settings for these analysis options, which can be changed by users as required.

Available analysis settings options

Analysis settings can be made applicable at the following levels:

System
Project
Database
Table
Column

The following table lists the available analysis options.

Table 1. Analysis settings
Analysis area	Analysis Function	Analysis Option	Default Setting	Description
Column Analysis	Properties	Nullability Threshold	1.0% Setting Range: 0.01 – 10.0%	If the column has null values with a frequency percent equal to or greater than the nullability threshold, inference is that the nullability flag is “YES.” If nulls do not exist in the column or the frequency percent is less than threshold, the nullability flag is inferred “NO.”
	Properties	Uniqueness Threshold	99.0% Setting Range: 90.0 – 100%	If the column has a percentage of unique distinct values equal to or greater than the uniqueness threshold, inference is that the uniqueness flag is “YES.” If the column has a percentage of unique distinct values less than threshold, the uniqueness flag is inferred “NO.”
	Properties	Constant Threshold	99.0% Setting Range: 90.0 – 100%	If the column has a single distinct value with a frequency percent equal to or greater than the constant threshold, inference is that the constant flag is “YES.” If there is no distinct value with a frequency count greater than the threshold, the constant flag is inferred “NO.”
Table Analysis	Primary Key Identification	Primary Key Threshold	99.0% Setting Range: 90.0 – 100%	If a column has a cardinality percentage equal to or greater than the primary key threshold, the column is inferred to be a primary key candidate as a single column.
	Primary Key Identification	Composite Key Maximum Columns	32 Setting Range: 2 – 32	The maximum number of columns that can be included in a Composite Key.