Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I am a beginner trying to understand the basic concepts of database's. I know several types of keys (Primary key, Foreign key, candidate key, super key, surrogate key.....etc). While learning about the degenerate dimension, I came across "dimension key".
In a data warehouse, a degenerate dimension is a dimension key in the fact table that does not have its own dimension table ----Ralph Kimball
Could someone please helps me understand the dimension key ?
A dimension key is the primary key of a dimension table.
In the example below, the "Time_key" column is the dimension/primary key of the Time dimension. This column will be used to join the dimension with fact tables, just like any other key.
in https://www.kimballgroup.com/1997/07/its-time-for-time/
A degenerate dimension is, however, a different and slightly more advanced concept to model. In the degenerate dim case, a fact table contains a foreign key that, by design, does not link to a dimension.
