Enhance from Map |
The Enhance from Map processor allows you to add a new attribute to the data by mapping matching values from an existing attribute.
Use Enhance from Map where new data can be derived from existing data. For example, records without a Gender, but with a gender-specific Title such as Mr or Mrs could have a new gender attribute added using Reference Data, with entries such as:
The single attribute to match against the lookup column in the map.
|
Option |
Type |
Purpose |
Default Value |
|
Reference Data |
The Reference Data with the map of the lookup value to the new attribute value |
None |
|
Option |
Type |
Purpose |
Default Value |
|
Ignore Case? |
Yes/No |
Whether or not to ignore case when matching against the Reference Data |
Yes |
|
Match list by |
Drives how to match the Reference Data |
Whole Value |
|
Data attribute |
Type |
Purpose |
Value |
|
EnhancedResult |
Added |
The new attribute containing the added (mapped) value |
The mapped value in the Reference Data, where there was a match. A Null value, where there was no match to the Reference Data. |
|
Flag attribute |
Purpose |
Possible Values |
|
EnhancedFlag |
Indicates which data has been enhanced |
Y/N |
|
Execution Mode |
Supported |
|
Batch |
Yes |
|
Real time Monitoring |
Yes |
|
Real time Response |
Yes |
The Enhance from Map processor produces a summary view of its results, showing the following statistics:
|
Statistic |
Meaning |
|
Enhanced |
The number of records that matched the reference list, and were therefore enhanced with a new attribute value. |
|
Unenhanced |
The number of records that did not match the reference list, and were therefore not enhanced. |
The following output filters are available from the Enhance from Map processor:
In this case, Enhance from Map is used to add an attribute renamed to TitleGender, where records have a gender-specific Title:
Oracle ® Enterprise Data Quality Help version 9.0
Copyright ©
2006,2011 Oracle and/or its affiliates. All rights reserved.