sneumersky (1/20/2014)
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 🙂
No problem 🙂 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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP