-
- Home
- Developer Center
- Documentation SSIS Data Masking Components
- Dictionary Substitution
Data Masking Components: Dictionary Substitution
-
Request
a trial -
Request
a demo -
Request
a quote
SSIS Data Masking Components
Open Navigation Article
-
- Home
- Developer Center
- Documentation SSIS Data Masking Components
- Dictionary Substitution
Data Masking Components: Dictionary Substitution
-
Request
a trial -
Request
a demo -
Request
a quote
Dictionary Substitution
Purpose
This component masks data by replacing values in a given set - such as a column in a table or a file-using a provided dictionary of substitution values. The mapping is not necessarily one-to-one; multiple original values may be mapped to the same replacement. However, the substitution is consistent within the dataset, ensuring that identical input values are always replaced with the same output value. This approach preserves referential integrity across the masked data.
Algorithm
Variation of Preserving Referential Integrity Substitution SUBSTITUTION PRESERVING REFERENTIAL INTEGRITY
Go to Tutorial
×
![Enlarged Picture]()
Data Masking Components: Dictionary Substitution
Download Manual
