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
Wikipedia	en.wikipedia.org/wiki/Surrogate_key

Articles about Surrogate key (2)

Dominar Power Query: transformar datos planos en un esquema en estrella
2026-08-12 · Mirko Peters
¡Bienvenido de nuevo al blog complementario del podcast! En el artículo de hoy profundizamos en la mecánica técnica del modelado de datos. Si alguna vez has heredado un volcado de
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,…

Glosario

Community wiki

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

Expertos y empresas para este tema

Nadie ha indicado aún este tema. Añádelo a tu 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