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).