Surrogate key

Concept

A surrogate key is a system-generated unique identifier, often a sequential number, that is not derived from business data and is used to relate tables such as fact and dimension tables.

Title graphic: Surrogate key (Concept)

Typ	Concept
Wikipedia	en.wikipedia.org/wiki/Surrogate_key

Articles about Surrogate key (2)

Opanowanie Power Query: przekształcanie płaskich danych w schemat gwiazdy
2026-08-12 · Mirko Peters
Witamy ponownie na blogu towarzyszącym podcastowi! W dzisiejszym wpisie zagłębiamy się w techniczne mechanizmy modelowania danych. Jeśli masz do czynienia z ogromnym, płaskim zrzut
Mastering Power Query: Transforming Flat Data into a Star Schema
2026-08-12 · Mirko Peters
Welcome back to the podcast companion blog! In today's post, we are diving deep into the technical mechanics of data modeling. If you have ever inherited a massive,…

Słownik

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Eksperci i firmy w tym temacie

Nikt jeszcze nie wskazał tego tematu. Dodaj go do swojego profilu.

Sources

Wikipedia: en.wikipedia.org/wiki/Surrogate_key
Feed for this topic (RSS): entity/surrogate-key/feed.xml
Articles on this topic: 2

Maintained by Mirko Peters (Microsoft MVP) · Last updated: 2026-11-03