Is surrogate key not the preferred option in dimension tables anymore? any suggestion

Sumanta Pandit, Consultant

Is surrogate key not the preferred option in dimension tables anymore? any suggestion
Is surrogate key not the preferred option in dimension tables anymore? any suggestion

Michelle Knight

RE: Is surrogate key not the preferred option in dimension tables anymore? any suggestion
(in response to Sumanta Pandit, Consultant)

Hi Sumanta,

From what I am reading, I think it depends on the context of the systems you have, the information you need and how fast you need it. It looks like some folks prefer not to use surrogate keys because of storage and performance issues.  One article talks about a passenger key that references the dimension table. Try reading https://www.sciencedirect.com/topics/computer-science/dimension-table

Also please elaborate on the context of your question.

 

Michelle Knight

[login to unmask email]

Freelance Production Assistant

Freelance Data, Technology and Science Writer