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