|
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 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.
Any String or String Array type attributes that you wish to use to generate Hash keys.
None
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. |
None
Execution Mode |
Supported |
Batch |
Yes |
Real time Monitoring |
Yes |
Real time Response |
Yes |
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.
None
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.