The Absolute Value transformation is a simple transformation that converts numbers to their absolute value, (that is, removing their sign (positive or negative), and stripping any unnecessary digits (such as zeroes at the beginning of the value)).
Use the Absolute Value transformation when for matching purposes you are concerned with only the absolute value of numbers, and not whether they are positive or negative, or whether they are stored in different formats (for example, with a different amount of digits stored).
None
In this example, the Absolute Value transformation is used to match volume amounts. The amounts are expected to be positive, but there may be occasional errors in the data where a negative amount has been specified.
Example transformations
The following table illustrates some example Absolute Value transformations:
|
Value |
Transformed value |
|
25 |
25 |
|
025 |
25 |
|
-25 |
25 |
|
500 |
500 |
|
0000500 |
500 |
|
-500 |
500 |
|
1.5 |
1.5 |
|
-1.5 |
1.5 |
Oracle ® Enterprise Data Quality Help version 9.0
Copyright ©
2006,2011 Oracle and/or its affiliates. All rights reserved.