Tuesday, September 9, 2008

sk for surrogate key

You might have noticed that every dimension table has a colum with _sk suffix on its name. These columns are surrogate keys. These columns (their data) do not come from the source; we generate them in our dimensional data warehouse. Surrogate key values are usually just meaningless sequential positive integers.

Every fact table that uses a dimension have the dimension's surrogate key; the surrogate keys link the fact to the dimension.

No comments: