15% Learning Discount Avail now

ETL Testing Training Forum

Top down approach DWH is 3NF form

Vanita Post 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



Support Team Reply 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.