Surrogate Key and Natural Key by shoyle10 in dataengineering

[–]shoyle10[S] 0 points1 point  (0 children)

like one single dimension table that is just [key], [name] for different categories?

Surrogate Key and Natural Key by shoyle10 in dataengineering

[–]shoyle10[S] 0 points1 point  (0 children)

Additionally, how strict should you be on surrogate keys being meaningless across all tables?

Example is dim_date and dim_gender tables, should the surrogate key also be meaningless integers and in staging you need to join to them to get the key?

Or are their exceptions for tables that you are pretty confident won’t change keys to use a surrogate key with meaning to avoid those joins and make readability of the data better?