Which statements about data warehousing is not correct?
A)The data warehouse should be separate from the operational system.
B)Data cleansing is a process of transforming data into standard form.
C)Drill-down is a data-mining tool available to users of OLAP.
D)Normalization is a requirement of databases included in a data warehouse.

Question

Quizplus · Accepted Answer

Normalization is not a strict requirement for databases included in a data warehouse as it can lead to performance issues when querying large amounts of data. Instead, denormalization is often used to improve query speed.

Which Statements About Data Warehousing Is Not Correct