Home Forums SQL Server 2005 Business Intelligence Foreign key constraints in data warehouses RE: Foreign key constraints in data warehouses
Hendra Eka Putra
SSCrazy
Points: 2015
More actions
March 8, 2008 at 11:48 pm
#787116
I agree that you should always add a FK in your data warehouse.
My other consideration is that you can always use the benefits of index between FK column in your fact table and PK in your dimension table if you want to drill through the data