~/ 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/a0ac3490-1cb0-496f-9e0c-9bdb00816088/flashcard utf-8 LF