The Key Type field drop-down includes options for Data Vault hash keys, e.g. Change Hash Key (c), Hub Hash Key (h), and Link Hash Key (l).
Hash Key source information is also displayed for these key types.
- Hash Key Sources – displays the source columns that are used to generate the selected Hub, Link, or Change hash key.
- Hash Key Source For – displays the hash keys columns that use the displayed hash key sources.
The hash key generation Wizard enables you to specify the source columns to be used in defining the Hub, Link, and Change hash key columns. The detailed steps for using this Wizard are described in Creating Data Vault Stage Tables.
Once the hash key columns have been defined, another Wizard is used to generate the procedure to populate the columns. The detailed steps for using this Wizard are described in Generating Update Procedures for the Data Vault Stage Table.