Comment by LewisC on Foreign Keys in a Data Mart

sschurig,

Interesting viewpoint. Thanks for sharing it. That’s the kind of info I was looking for.

I agree with at least putting them in and not enforcing. That would be at a minimum, for me.

I do disagree with some of your points, though. I believe the db should be the final say of RI. I actually use RI when doing ETL to make the ETL less complicated. Why put it in code when it can go into the database?

I have seen and worked with a huge number of data