SQL: Is there a need to check RI in data warehouses?

added by DotNetKicks
11/23/2018 2:01:01 PM

1 Kicks, 2678 Views

Betteridge's law of headlines says that any headline that asks a question can be answered "no". Well, contrary to that law, the TLDR answer to this is "yes". I'm endlessly reading information that says that if your referential integrity is being checked in your OLTP application that's providing data for your data warehouse, that you ...