In this example, supplier_code is the natural key and supplier_key is a surrogate key. technically, the surrogate key is not necessary, since the table
Using t-sql merge to load slowly changing dimensions can be tricky. learn the fundamentals and pitfalls to avoid.
Slowly changing dimensions: slowly changing dimensions are the dimensions in which the data changes slowly, rather than changing regularly on a time basis.