The short answer
A is an artificial identifier created by the warehouse (integer sequence, UUID, or hash), not a business key from the source system.
dim_product
product_sk = 918273 <-- surrogate (warehouse-owned)
sku = 'SKU-44' <-- natural / business key
category = 'Shoes'Why they matter
- Source can change, recycle, or collide across systems
- needs a new key per version while
skustays the same - Facts join on stable warehouse keys, not fragile source strings
Mental model
The business still talks about SKU-44. The warehouse uses product_sk as the internal handle so history and joins stay stable.
Facts store surrogates
fct_order_item.product_sk points at the dimension version that applied at order time.
Interview tip
> "Surrogate keys are warehouse-generated. Natural keys come from the business. SCD2 and multi-source integration are why we prefer surrogates in dims and facts."