In the last few days I tested several ways to generate surrogate keys when loading a dimension into a data mart. The classical approach with SQL Server is to rely on a INT IDENTITY column. It works fine, but you don't know what surrogate key has been
Read More...