Hopefully, the initial forum poster got the answers he/she was seeking, and my apologies to Koen for adding my $.02 when I probably did not need to :-)
Healthy discussions are always appreciated.
Personally I almost never use FKs in the data warehouse. They stand in the way of my truncate table statements :-)
But, the ETL has the responsability though to make sure data integrity is intact. Lookups are done before rows are inserted into a fact table. If the lookup fails, the row has to be dealt with before it goes into the fact table.
How to post forum questions.Need an answer? No, you need a question.What’s the deal with Excel & SSIS?
Member of LinkedIn
. My blog at SQLKover
MCSA SQL Server 2012 - MCSE Business Intelligence