|
|
Expression |
The Expression processor allows you to write an expression which may encompass the logic of a number of other OEDQ processors and other functions, using an abbreviated expression language.
Expressions are useful where the required logic of a processor can be expressed most logically and succinctly by writing an expression, rather than by configuring several processors. This is commonly the case when performing mathematical operations, for example.
The Expression processor may take any number of inputs, of any type, with the exception of formal Date attributes.
|
Option |
Type |
Purpose |
Default Value |
|
Expression to evaluate |
Expression |
The required processor logic, in OEDQ's expression language. See notes below. |
None |
Click for detailed notes on OEDQ's expression language.
|
Data attribute |
Type |
Purpose |
Value |
|
ExpressionResult |
Added |
Stores the result of the expression |
An attribute with the result of the expression. The attribute type depends on the expression. See notes above. |
None
|
Execution Mode |
Supported |
|
Batch |
Yes |
|
Real-time Monitoring |
Yes |
|
Real-time Response |
Yes |
The Expression processor presents no summary statistics on its processing.
In the Data view, each input attribute is shown with the ExpressionResult attribute to the right.
None
In this example, the Expression processor is used to divide one numeric attribute value by another.
The following two attributes are input, and the output attribute (ExpressionResult) renamed to DerivedLTV1:
The following expression is used:
Results:
Oracle ® Enterprise Data Quality Help version 9.0
Copyright ©
2006,2011 Oracle and/or its affiliates. All rights reserved.