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.
| Type | Concept |
|---|---|
| Wikipedia | en.wikipedia.org/wiki/Surrogate_key |
Articles about Surrogate key (1)
- Mastering Power Query: Transforming Flat Data into a Star Schema
· 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,…
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: 1
Maintained by Mirko Peters (Microsoft MVP) · Last updated: