No Data Check |
The No Data Check processor provides a simple way of checking whether or not there is any meaningful data in an attribute, or across a number of attributes.
The No Data Check checks not only for null values, but also for empty Strings, and values consisting entirely of spaces or non-printing characters - though only null values will exist if the data has already undergone No Data Handling in the snapshot, or in the Reader processor.
If a record has any data other than whitespace in any of the attributes analyzed, it is categorized as containing data. Otherwise, if all attributes analyzed contain No Data, it is categorized as containing no data.
Use the No Data Check processor to check for complete and incomplete values in an attribute, or across a number of attributes. For example, you may wish to check for all records that have a missing Gender value, and add it where possible using the data available, perhaps by mapping from a Title attribute. Or, you may wish to isolate all records that have no data at all in a number of Name or Address fields.
Any number of attributes that you wish to check for completeness.
Option |
Type |
Purpose |
Default Value |
Check for No Data in: |
Selection (Any attributes/All attributes) |
This option drives whether to mark records as having No Data if they have No Data in all of the input attributes, or if they have No Data in any of the input attributes. |
All attributes |
None
Flag attribute |
Purpose |
Possible Values |
DataFlag |
Indicates which data passes the No Data Check. |
Y/N |
The results of a No Data Check may be published to the Dashboard.
The following interpretation of results is used by default:
Result |
|
Contains Data |
Pass |
No Data |
Alert |
Execution Mode |
Supported |
Batch |
Yes |
Real time Monitoring |
Yes |
Real time Response |
Yes |
The No Data Check processor produces a summary view of its results, showing the following statistics:
Statistic |
Meaning |
Without Data |
The number of records without data in the checked attributes. |
With Data |
The number of records with data in the checked attributes. |
The following output filters are available from a No Data Check:
In this example, the No Data Check is used to find records without an email address (in an EMAIL attribute):
Summary View
Drilldown on Without Data
Oracle ® Enterprise Data Quality Help version 9.0
Copyright ©
2006,2011 Oracle and/or its affiliates. All rights reserved.