We've talked about using a surrogate key in your data warehouse whether that's Azure Synapse Analytics or something else. Patrick looks at why you should consider this even if you aren't using a slowly changing dimension.
To Surrogate Key or Not…pleblanc2023-01-03T07:53:08-05:00