Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.

Every key used to join the fact table with a dimensional table should be a surrogate key.

Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.

Static extract is used for ongoing warehouse maintenance.

Both status data and event data can be stored in a database.