You are here: Processor Library > Audit > No Data Check

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

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.

Configuration

Inputs

Any number of attributes that you wish to check for completeness.

Options

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

Outputs

Data attributes

None

Flags

Flag attribute

Purpose

Possible Values

DataFlag

Indicates which data passes the No Data Check.

Y/N

Publication to Dashboard

The results of a No Data Check may be published to the Dashboard.

The following interpretation of results is used by default:

Result

Dashboard Interpretation

Contains Data

Pass

No Data

Alert

Execution

Execution Mode

Supported

Batch

Yes

Real time Monitoring

Yes

Real time Response

Yes

Results Browsing

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.

Output Filters

The following output filters are available from a No Data Check:

Example

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.