You are here: Processor Library > Transformation > Hash Generator

Hash Generator

The Hash Generator processor creates a Hash key for each input attribute. The output Hash key will be the same (and unique) for each distinct data value that is input to it.

Use

Use the Hash Generator processor where you want to create a key in a set of data that will remain the same provided the input attribute retains the same value.

Hash keys are often used when 'diffing' data, for example to create processes that only run various processors on records that have changed in important attributes since the last time they were processed.

It is common to use the Concatenate processor before the Hash Generator to concatenate a number of attributes into a single attribute, and use that single attribute to generate the Hash key. The Hash key will then stay the same as long as the exact values of all the attributes passed into the Concatenate processor stay the same.

Configuration

Inputs

Any String or String Array type attributes that you wish to use to generate Hash keys.

Options

None

Outputs

Data attributes

Data attribute

Type

Purpose

Value

[Attribute Name].Hash

Derived

The Hash key derived from the version of each input attribute value.

The original attribute value, converted to a Hash key.

Flags

None

Execution

Execution Mode

Supported

Batch

Yes

Real time Monitoring

Yes

Real time Response

Yes

Results Browsing

The Hash Generator processor presents no summary statistics on its processing.

In the Data view, each input attribute is shown with its new derived Hash key attribute to the right.

Output Filters

None

Example

In this example, a concatenated NAMEANDADDRESS attribute, derived from all name and address attributes, is used to generate a Hash key for each record:

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