Data Modeling Interview Question:

When should you consider denormalization?

Submitted by: Administrator

Denormalization is used when there is a lot of tables involved in retreiving data.Denormalization is done in dimentional modelling used to construct a data ware house.This is not usually done for data bases of transactional systems.
Submitted by: Administrator