Home > Using the Data Miner GUI > Oracle Data Miner Functiona... > View Menu > Tools Menu > Data Miner Preferences > Filter Columns
These preferences specify the behavior of the Filter Columns transformation.
You can specify the following Data Quality criteria:
% Nulls less than or equal indicates the largest acceptable percent of NULL
values in a column of the data source. The default value is 95%.
% Unique less than or equal indicates the largest acceptable percent of values that are unique a column of the data source. The default value is 95%.
% Constant less than or equal indicates the largest acceptable percent of constant values in a column of the data source.
Attribute Importance is not selected by default. You can specify these settings:
Importance Cutoff, a number between 0 and 1.0. The default cutoff is 0.
Top N, the maximum number of attributes; default is 100.
The column filter by default uses Sampling to determine data quality and attribute importance. The default is to use a Sample Size of 2,000 records. You can turn off sampling, that is use all of the data, or increase the sample size.