Bhanu

• Jan 25th, 2007

 

a data warehousing best practice is to create surrogate keys--typically a meaningless simple integer--for the primary key in each dimension table. The associated fact table rows use this same surrogate as a foreign key reference to the dimension tables.