It is an artificial key field, usually with system-assigned sequential numbers, used in the dimensional model to link a dimension table to the fact table. In the dimensional table, the surrogate key is the primary key which becomes a foreign key in the fact table.
No comments:
Post a Comment