Algorithm: Min-Max (KBA1754)
This algorithm trims (low and high) edge values and sets them to the nearest min and max value. Any string that is not a value can be converted to a value/string specified in the Out of Range Replacement Value. This works for numbers, dates, and one or more multiple values in a string with text.
This algorithm has many features:
- Algorithm-based
- Very small memory usage
- Fast
- Multiple values in a string
If all values in a text need to be 'masked', this algorithm works on multiple values in a string. - Replacement Value
If a value is replaced with a word (for example "n/a") for a specific reason, these strings can be replaced with a value. This can for example be the CEO's salary, which might have been specified as 'unknown', but will also identify the CEO in the data. The string 'unknown' therefore can be replaced with a value.
At a Glance
Versions: | Applicable Delphix Masking versions: 4.x, 5.0.x, 5.1.x, 5.2.x, 5.3.x | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Description: |
This algorithm has a specific use. It is used to normalize data within a range – for example, 18 to 80. Any value below or above that is trimmed and moved to the min or the max value. If a non-numeric value is used (that is, not available), this can be replaced with a value specified in the Out of Range Replacement Value. This algorithm works also on multiple values in a string. |
||||||||||||||
Characteristics: |
This algorithm trims identifying edge values and is not masking any other value. 1 Unique Lookup - Not applicable. |
||||||||||||||
Character Encodings: |
US-ASCII 7 bit numeric characters. |
||||||||||||||
Lookup Pool Size: | Not applicable. | ||||||||||||||
Limitations: | Is not masking any values (use Secure Lookup for that). | ||||||||||||||
Customization: |
Creation: Min, max and if used Out of range Replacement value. Modify: All parameters can be modified. |
Creating and Modifying Algorithms
The Min-Max algorithm has is created and can be accessed from the tab Settings and under the submenu Algorithm.
From the Algorithm page, Min-Max algorithm can be created and also modified (edit):
- To create click "Add Algorithm".
- To modify click the green pen in the "Edit" column.
User Interface
The following popup is accessed when creating and modifying the algorithm:
All parameters except the name can be modified.
- Algorithm Properties
- Algorithm Name
Can only be created, not modified. - Description
- Algorithm Name
- Algorithm Parameters
- Number Range with Min and Max
- Date Range with Min Date and Max Date
- Out of range Replacement Values
Considerations
Replacement Value
When using Replacement Value, this will not work in a text string as all text in the string will be replaced with the value/string in the Out of range Replacement Value.
Examples
The three example below highlight masked results. Three algorithms used are one without Out of range Replacement Value (OorRV) and two with (one with a number and one with a string).
+---------------+-----+-----+-------+
| Algorithm | Min | Max | OorRV |
+---------------+-----+-----+-------+
| MinMax | 10 | 30 | 25 |
+---------------+-----+-----+-------+
| MinMax_OorRV1 | 10 | 30 | 25 |
+---------------+-----+-----+-------+
| MinMax_OorRV2 | 10 | 30 | na |
+---------------+-----+-----+-------+
Result
+----+------------------------+-------------------------+-------------------+-------------------+ | | | | Masked | Masked | | ID | Orig | Masked | w OorRV = 25 | w OorRV = na | +----+------------------------+-------------------------+-------------------+-------------------+ | 1 | 1 | 10 | 10 | 10 | +----+------------------------+-------------------------+-------------------+-------------------+ | 2 | 5 | 10 | 10 | 10 | +----+------------------------+-------------------------+-------------------+-------------------+ | 3 | 10 | 10 | 10 | 10 | +----+------------------------+-------------------------+-------------------+-------------------+ | 4 | 15 | 15 | 15 | 15 | +----+------------------------+-------------------------+-------------------+-------------------+ | 5 | 20 | 20 | 20 | 20 | +----+------------------------+-------------------------+-------------------+-------------------+ | 6 | 50 | 30 | 30 | 30 | +----+------------------------+-------------------------+-------------------+-------------------+ | 7 | 100 | 30 | 30 | 30 | +----+------------------------+-------------------------+-------------------+-------------------+ | 8 | unknown | unknown | 25 | na | << Using OorRV the text is replaced with a value. +----+------------------------+-------------------------+-------------------+-------------------+ | 9 | n/a | n/a | 25 | na | +----+------------------------+-------------------------+-------------------+-------------------+ | 10 | n a | n a | 25 25 | na na | << Space separates words and that means two replacements. +----+------------------------+-------------------------+-------------------+-------------------+ | 11 | Txt1 1 Txt2 15 Txt3 50 | Txt1 10 Txt2 15 Txt3 30 | 25 10 25 15 25 30 | na 10 na 15 na 30 | << The algorithm works on long text strings. +----+------------------------+-------------------------+-------------------+-------------------+
Applicable Delphix Versions
This article applies to the following versions of the Delphix Engine:
Major Release |
Sub Releases |
5.3 | 5.3.0.0 |
5.2 | 5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1 |
5.1 |
5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0 |
5.0 |
5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4 |
4.0 |
4.0.0.0, 4.0.0.1, 4.0.1.0, 4.0.2.0, 4.0.3.0, 4.0.4.0, 4.0.5.0, 4.0.6.0, 4.0.6.1 |