~/ learn/ comp-378/ cards/ Why Warehouse? Operational vs. Informational & the Four Defining Traits
1 of 4

Define a data warehouse using its four defining characteristics.

Define a data warehouse using its four defining characteristics.

Answer

A subject-oriented, integrated, time-variant, nonupdateable collection of data used to support management decision-making.

Subject-oriented (organized by business subject), integrated (one consistent version of the truth across sources), time-variant (every fact tied to a time period), nonupdateable (loaded/refreshed by ETL, never edited by users).

space flip · ← → navigate · esc to exit
NORMAL ~/memra/library/abda8878-319c-49ac-9288-bd0c0e5af11d/flashcard utf-8 LF