Retaining relational integrity between the fact table and its dimensions is very important. The data warehouse can become a trusted repository for enterprise data only if the data is clean and its integrity is intact. If, because of operational problems, you can't justify leaving the fact table foreign key constraints in place, plan to execute a periodic program that searches for violations of referential integrity and reports on them, so you can remedy the situation. It’s one thing to hav...