DrivingKeyLink_HK

Description

The Default Term named DrivingKeyLink_HK  contains the Hask Key of the Business Keys that define the Driving Key of a Driving Key Link.

Format

The DrivingKeyLink_HK  is a binary(20).

Value

It contains the Hask Key of the row calculated with the Terms declared as Business Key, which defines the Driving Key in the Driving Key Link. It uses the SHA1 algorithm.

Example for a Driving Key Link with the Terms named FK_MD_Employee_Hub_HK

HASHBYTES('SHA1', ISNULL(CAST([FK_MD_Employee_Hub_ID] AS NVARCHAR(4000)), '_NULL_') + '_' + ISNULL(CAST([FK_MD_Company_Hub_ID] AS NVARCHAR(4000)), '_NULL_')) AS [DrivingKeyLink_HK]

Example of values: