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

  • March 10, 2008 at 1:09 pm

    #787556

    Loner (2/7/2008)

    The cleansing routine is done during the ETL process. After the data loaded into the dimension table, it is not guaranteed that no one would delete it.

    To put a foreign key in the fact table is used for data integrity.

    Users and Apps should not be deleting records or making any other permanent modifications to an OLAP database. Only the ETL should be doing that.

    [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]