Home Forums SQL Server 2005 Business Intelligence Foreign key constraints in data warehouses RE: Foreign key constraints in data warehouses

  • March 9, 2008 at 10:56 pm

    #787202

    Chuck Bevitt (2/7/2008)

    My question is, when the data warehouse database is implemented in SQL Server 2005, is there any point to adding SQL Server foreign key constraints between the fact and the dimension tables?

    I wouldn't do it. Foreign Keys are really antithetical to the purpose and philosophy of OLAP and data warehouses.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]