The Key Type field drop-down include 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 are 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 is 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 is described in Generating Update Procedures for the Data Vault Stage Table.