medium10 pts · first answer countsdata-warehousingdimensional-modelling
Surrogate keys in dimensions
Why do dimension tables usually use a warehouse-generated surrogate key instead of the source system's customer ID as the primary key?
Discussion 0
Join free to post in the discussion.
Related questions
- A fully additive measureData Engineer
- Invoice number in the fact tableData Engineer
- Why keep a date dimensionData Engineer
- One customer dimension for two factsData Engineer
- Kimball versus InmonData Engineer
- OLTP and OLAP workloadsData Engineer
- Why warehouses store columnsData Engineer
- Facts and dimensionsData Engineer