V
Vanita Posted on 29/11/2018
As it is mentioned  in 1st module that DWH is denormalized. Module 8 says, in Top down approach DWH follows 3 NF form. both satements are contradicting. Please clarify on this

A
Ashish Thakur Replied on 12/01/2019

Data warehouses are designed to accommodate ad hoc queries, Data warehouses often use denormalized or partially denormalized schemas (such as a star schema) to optimize query performance. OLTP systems often use fully normalized schemas to optimize update/insert/delete performance, and to guarantee data consistency.