BG_RowHash

Description

The Default Term named BG_RowHash contains the Hask Key to uniquely identify a row in a Satellite or a Link Satellite.

Format

The BG_RowHash is a binary(20).

Value

It contains the Hask Key of the row calculated with all the Terms (except the Foreign Key Terms) in the Satellite or Link Satellite. It uses the SHA1 algorithm.

Example for a Satellite with the Terms named Marital_Status, Gender, and Number_Of_Children :

HASHBYTES('SHA1', ISNULL([Marital_Status], '_NULL_') + '_' + ISNULL([Gender], '_NULL_') + '_' + ISNULL(CAST([Number_Of_Children] AS NVARCHAR(200)), '_NULL_')) AS [BG_RowHash]

Example of values: