- Home
- Developer Center
- Documentation SSIS Data Masking Components
- Zip Code 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
- Zip Code Dynamic
Zip Code Dynamic
Purpose
Masking Zip Code Dynamic component replaces real U.S. ZIP codes with randomly generated alternatives based on currently active three-digit prefixes and transforms Canadian postal codes in the A1A A1A format into other valid postal codes. It applies 18 Safe Harbor statistical rules to ensure outputs remain realistic and statistically sound. The component operates deterministically, retaining referential integrity by consistently substituting the same input values across datasets. It fails on input values that violate expected formats, enabling robust error detection and handling.
Algorithm
Variation of Random Character Permutation Algorithm
×
Data Masking Components: Zip Code Dynamic
Data Masking Components: Zip Code Dynamic
SSIS Data Masking Components
Components Specification
Trial Installation Help
Process Architecture Help
SSIS Help