You are here: Processor Library > Transformation > Enhance from Map

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

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:

Configuration

Inputs

The single attribute to match against the lookup column in the map.

Options

Value Map

Option

Type

Purpose

Default Value

Reference Data

Reference Data

The Reference Data with the map of the lookup value to the new attribute value

None

Match Options

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

Selection (Whole Value/Starts With/Ends With/Contains)

Drives how to match the Reference Data

Whole Value

Outputs

Data attributes

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.

Flags

Flag attribute

Purpose

Possible Values

EnhancedFlag

Indicates which data has been enhanced

Y/N

Execution

Execution Mode

Supported

Batch

Yes

Real time Monitoring

Yes

Real time Response

Yes

Results Browsing

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.

Output Filters

The following output filters are available from the Enhance from Map processor:

Example

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.