medium10 pts · first answer countsdata-modellingkeys

Hashing a business key for a surrogate

In a lakehouse with parallel loads and no database sequences, why do teams often use MD5 or SHA of the business key as the surrogate key?

A.Hashes are always shorter than integer keysB.Hash keys keep rows stored in insert orderC.Any job can compute the same key without a lookupD.It hides the business key from every user

Discussion 0

Join free to post in the discussion.

Hashing a business key for a surrogate

Discussion 0

Related questions