- Home
- Developer Center
- Documentation SSIS Data Masking Components
- Generic Phone Nu Dynamic
SSIS Data Masking Components
Components Specification
Trial Installation Help
Process Architecture Help
SSIS Help
SSIS Data Masking Components
Open Navigation Article
- Home
- Developer Center
- Documentation SSIS Data Masking Components
- Generic Phone Nu Dynamic
Generic Phone Nu Dynamic
Purpose
This version functions similarly to the random variant, masking numeric digits while preserving all original separators, formatting characters and first digits (phone Number length - 7). It supports phone numbers of variable length (9-15), but it adds referential integrity: the same original phone number will always produce the same masked output within a dataset.
Examples:
- +44 20 7946 0958 → +44 20 4162 3057
- +44 20 7946 0958 → +44 20 4162 3057
- 0034.912.345.678 → 0034.204.837.591
- +49-89-636-48018 → +49-89-382-60214
Key features:
- Preserves all special characters (e.g., +, -, ., (, ), spaces) as they appear in the input
- Only replaces numeric digits
- Does not allow alphabetic characters in the input
- Preserving first 4 digits
- Min – 9 digits. Max - 15 digits
- Same input → same output within the masked result set
The length and structure of the phone number are maintained by preserving the number of digits and position of separators. This allows for realistic-looking masked numbers while protecting the original values.
Algorithm
Variation of Random Character Permutation Algorithm
×
Data Masking Components: Generic Phone Nu Dynamic
Data Masking Components: Generic Phone Nu Dynamic
SSIS Data Masking Components
Components Specification
Trial Installation Help
Process Architecture Help
SSIS Help