Home Forums SQL Server 2005 Business Intelligence Foreign key constraints in data warehouses RE: Foreign key constraints in data warehouses
Loner
SSC-Insane
Points: 21279
More actions
February 7, 2008 at 12:54 pm
#776153
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.