-
Request
a trial -
Request
a demo -
Request
a quote
-
Request
a trial -
Request
a demo -
Request
a quote
SSIS Load Dictionary Component
Purpose
The purpose of the Load Dictionary component is to create a custom dictionary of values for the later use in Dictionary Substitution component. If the data schema includes certain elements that could not be masked using substitution components with pre-packaged data sets such as names or companies, then this component allows you to create a set of (key,value) pairs in memory. Dictionary Substitution component picks up the values and replaces them with the substitution algorithm. Examples might include creating sets of "languages" from the language table, or "brands" from the brand table in the database, etc.
Algorithm
While none of the data masking algorithms are applicable, Load Dictionary simply retrieves a data set from the indicated source and makes it available via Object type variable.
Go to Tutorial
Data Masking Components: Load Dictionary
Download Manual
