Open Studio for Data Quality
This section describes indicator parameters displayed in the different Indicators Settings dialog boxes.
|Minimal value||Beginning of the first bin.|
|Maximal value||End of the last bin.|
|Number of bins||Number of bins.|
|Aggregate nulls with blanks||When selected, null data is counted as zero length text field. This means that null data is treated as an empty string. When not selected, null data is treated as any other text data.|
|Aggregate blanks||When selected, blank texts (e.g. " ") are all grouped together
and considered as an empty string. When not selected, blank texts
are treated as any other text data.
Note: In Oracle, empty strings and null strings are the same objects. Therefore, you must select or clear both check boxes in order to get consistent results.
|Lower threshold||Data smaller than this value should not exist.|
|Upper threshold||Data greater than this value should not exist.|
Value Frequency Parameters
|Number of results shown||Number of displayed results.|
|Lower threshold||Lower threshold of matching indicator values.|
|Upper threshold||Higher threshold of matching indicator values.|
|Lower threshold(%)||Lower threshold of matching indicator values in percentage relative to the total row count.|
|Upper threshold(%)||Higher threshold of matching indicator values in percentage relative to the total row count.|
|Expected value||Only for the Mode indicator in the Advanced Statistics. Most probable value that should exist in the selected column.|
|Characters to replace||List of the characters to be replaced.|
|Replacement characters||List of the characters that will take the place of the replaced
Note: Each character of the first field will be replaced by the character at the same position from the second field. For example, with the values "abc0123ABC,;.:" in the first field and "aaa9999AAApppp" in the second field any "a", "b" or "c" will be replaced by "a" and any "0", "1", "2" or "3" will be replaced by "9".
|Country||Country ISO2 code of the phone number.|
|Ignore case||When selected, comparison of text data is not case sensitive.|
|Count nulls||When selected, null data is counted as zero length text field.|
|Count blanks||When selected, blank texts (e.g. " ") are counted as zero length text fields.|