The Date Edit Distance comparison determines the Character Edit Distance between two Date values.
Use the Date Edit Distance comparison to find either exact or close date matches. Use Date Edit Distance when dates have been manually specified in a system, rather than generated automatically, so the dates may be subject to typographical errors - for example to identify the values "01/08/1972" and "01/08/1772" as a possible match with a Date Edit Distance of 1.
This comparison supports the use of result bands.
|
Option |
Type |
Purpose |
Default Value |
|
Match No Data pairs? |
Yes/No |
This option determines the result of a comparison when it compares two No Data (Null, or containing only whitespace characters) values for an identifier. If set to No, the comparison will give a 'no data' result when comparing a No Data value against another No Data value. If set to Yes, the comparison will give a full match (a Date Edit Distance of 0) when comparing a No Data value against another No Data value. A 'no data' result will only be returned if a No Data value is compared against a populated value. |
No |
|
Ignore day? |
Yes/No |
Ignore day allows the day part of the date to be ignored when matching. If set to Yes, the day will be ignored when matching. For example, "11/01/1975" will match "23/01/1975" with an edit distance of 0. If set to No, the day will be used when matching. For example, "11/01/1975" will match "11/01/1975" with an edit distance of 0, but "11/01/1975" and "23/01/1975" will match with an edit distance of 2. |
No |
|
Ignore month? |
Yes/No |
Ignore month allows the month part of the date to be ignored when matching. If set to Yes, the month will be ignored when matching. For example, "08/01/1975" will match "08/08/1975" with an edit distance of 0. If set to No, the month will be used when matching. For example, "08/08/1975" will match "08/08/1975" with an edit distance of 0, but "08/01/1975" and "08/08/1975" will match with an edit distance of 1. |
No |
|
Ignore year? |
Yes/No |
Ignore year allows the year part of the date to be ignored when matching. If set to Yes, the year will be ignored when matching. For example, "11/01/1901" will match "11/01/1875" with an edit distance of 0. If set to No, the year will be used when matching. For example, "11/01/1975" will match "11/01/1975" with an edit distance of 0, but "11/01/1901" and "11/01/1875" will match with an edit distance of 3. |
No |
|
Ignore century? |
Yes/No |
Ignore century allows the century part of the date to be ignored when matching. Note that the Ignore century option will only apply if Ignore year = No. If Ignore year = Yes, the entire year part of the date is always ignored. If set to Yes, the century will be ignored when matching. For example, "11/01/1901" will match "11/01/2001" with an edit distance of 0, and "11/01/1975" will match "11/01/1874" with an edit distance of 1. If set to No, the century will be used when matching. For example, "11/01/2001" will match "11/01/2001" with an edit distance of 0, but "11/01/1901" and "11/01/2001" will only match with an edit distance of 2. |
No |
|
Time zone |
Time Zone |
Sets the time zone to use when comparing the two date/time values. |
Director Time Zone |
Example configuration
In this example, the Date Edit Distance comparison is used on a Date of Birth identifier to match people. Exact date matches (where the edit distance is 0) are categorized as matches, if the Name also matches. Close date matches (where the edit distance is 1) are categorized as possible matches (for review), if the Name also matches.
Match No Data pairs? = No
Ignore day? = No
Ignore month? = No
Ignore year? = No
Ignore century? = Yes
Time zone = Director Time Zone
Example results
The following table illustrates some example comparison results using the above configuration:
|
Value A |
Value B |
Comparison result (Date Edit Distance) |
|
11/01/1960 |
11/01/1960 |
0 |
|
11/01/1860 |
11/01/1960 |
0 |
|
05/08/1972 |
05/08/1772 |
0 |
|
11/01/1960 |
11/11/1960 |
1 |
|
11/01/1912 |
11/01/1970 |
2 |
|
11/08/1960 |
08/11/1960 |
4 |
|
25/06/1982 |
11/08/1960 |
5 |
Oracle ® Enterprise Data Quality Help version 9.0
Copyright ©
2006,2011 Oracle and/or its affiliates. All rights reserved.