O'Reilly logo
  • krishn patel thinks this is interesting:

The greatest danger, therefore, comes from deleting dimension rows,
which is not a common practice in data warehousing

From

Cover of The Data Warehouse Lifecycle Toolkit

Note

ON DELETE - CASCADE