Default Terms
      Back to home
      1. biGENIUS-X Knowledge Base
      2. Generators
      3. Default Terms

      Hub_HK

      Description

      The Default Term named Hub_HK  contains the Hask Key to identify a row in a Hub uniquely.

      Format

      The Hub_HK is a binary(20).

      Value

      It contains the Hask Key of the row calculated with the Terms declared Business Key in the Hub. It uses the SHA1 algorithm.

      Example for a Hub with the Term named AccountNumber as Business Key:

      HASHBYTES('SHA1', ISNULL([AccountNumber], '_NULL_')) AS [Hub_HK]

      Example of values: