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)

Tipo	Concept
Wikipédia	en.wikipedia.org/wiki/Surrogate_key

Articles about Surrogate key (2)

Dominando o Power Query: transformando dados planos em um esquema em estrela
2026-08-12 · Mirko Peters
Bem-vindo de volta ao blog complementar do podcast! No post de hoje, vamos mergulhar fundo na mecânica técnica da modelagem de dados. Se você já herdou uma exportação gigante e pla
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,…

Glossário

Community wiki

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

Especialistas e empresas para este tópico

Ninguém indicou ainda este tópico. Adicione-o ao seu perfil.

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