You are here: Processor Library > Audit > Logic Check

Logic Check

The Logic Check processor enables users to perform a logic check, using multiple criteria to route or filter records.

Use

The Logic Check processor is normally used as a way to filter records to a required set. For example, if all records are passed through a number of checks, it may be useful to add a Logic Check at the end to select which records are considered as overall passes and fails, using the Flag attributes added by other audit processors.

Logic Check may also be used to filter down records to a specific set where the data matches a number of criteria across a number of attributes.

Configuration

Inputs

Any number of attributes of any type (except arrays).

Options

Option

Type

Purpose

Default Value

Input attributes and logic operators (AND, OR, NOT AND, NOT OR)

GUI led expression builder.

To build an expression from the input attributes.

None

Note that the options specified drive the construction of an expression that is used to filter records. It is also possible to edit the expression directly, once you have mastered how the expressions are written. The expressions may also be used in the Expression Filter custom processor.

Outputs

Data attributes

None

Flags

Flag attribute

Purpose

Possible Values

LogicValid

Indicates which data passes the Logic Check

Y/N

Publication to Dashboard

Result

Dashboard Interpretation

Valid

Pass

Invalid

Alert

Execution

Execution Mode

Supported

Batch

Yes

Real time Monitoring

Yes

Real time Response

Yes

Results Browsing

Statistic

Meaning

Records Passing Check

The number of records which pass the logic check

Records Failing Check

The number of records which fail the logic check

Output Filters

The following output filters are available from a Logic Check:

Example

In the example below, the user wishes to filter the records which have all of the following attributes populated: NAME, ADDRESS1, POSTCODE, EMAIL.  These attributes are profiled in the Quickstats profiler first to generate the Populated flags.

Summary view

 

Drilldown on Records Passing Check

Drilldown on Records Failing Check

Oracle ® Enterprise Data Quality Help version 9.0
Copyright © 2006,2011 Oracle and/or its affiliates. All rights reserved.