Surrogate key

A surrogate key is a technical identifier, often an integer or a hash, assigned to each row of a dimension in place of the business key. It insulates the warehouse from changes in the source systems and makes it possible to keep several versions of the same entity, notably for historizing dimensions.

Example

ROW_NUMBER() OVER (ORDER BY id_client) AS client_key

Related concepts

The whole glossary