Data Masking Components: Load Dictionary
Search
OpenNavigationArticle
SSIS Data Masking Components
OpenNavigationArticle
Open Navigation Article
Data Masking Components: Load Dictionary
  • Request Trial Request
    a trial
  • Request Demo Request
    a demo
  • Request Quote 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.

TutorialIcon Go to Tutorial
About Hush-Hush Contact Us

E-mail: info@mask-me.net

tel: 855.968.4874

Privacy Policy Terms of Use