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:
Post a Comment