|
Logic Check |
The Logic Check processor enables users to perform a logic check, using multiple criteria to route or filter records.
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.
Any number of attributes of any type (except arrays).
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.
None
Flag attribute |
Purpose |
Possible Values |
LogicValid |
Indicates which data passes the Logic Check |
Y/N |
Result |
Dashboard Interpretation |
Valid |
Pass |
Invalid |
Alert |
Execution Mode |
Supported |
Batch |
Yes |
Real time Monitoring |
Yes |
Real time Response |
Yes |
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 |
The following output filters are available from a Logic Check:
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.