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)

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

Articles about Surrogate key (2)

Menguasai Power Query: Mengubah Data Datar menjadi Skema Bintang
2026-08-12 · Mirko Peters
Selamat datang kembali di blog pendamping podcast! Dalam artikel hari ini, kita akan menyelami mekanika teknis pemodelan data. Jika Anda pernah mewarisi data mentah yang besar dan
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,…

Glossary

Community wiki

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

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.

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