Re: quick FK question
Date: Wed, 23 Dec 2009 08:48:14 -0500
There's another aspect to this conversation with regards to the fact that for warehouse implementations foreign key constraints are often times *enforced* in the ETL process and not in the database definition. Insofar as that's the case, the extra expense you describe in checking that foreign key relationships tie back to a parent record row isn't incurred.
RumpiReceived on Wed Dec 23 2009 - 07:48:14 CST