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

      Pit_HK

      Description

      The Default Term named Pit_HK  contains the Hask Key to identify a row in a PIT Table uniquely.

      Format

      The Pit_HK is a binary(20).

      Value

      It contains the Hask Key of the row calculated with the Terms declared as Business Key in the Hub of the Satellites or the Link of the Link Satellites used in the PIT Table. It uses the SHA1 algorithm.

      Example for a PIT Table with the Term named AccountNumber as Business Key of the Hub of the Satellites used in it:

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

      Example of values: