Denormalization is the process of undoing the normalization done in a typical database design.t means allowing for redundant data to reduce the number of multi-table (or view) joins necessary. Denormalization is ideal for reporting (OLAP) systems.
suppose you have normalized territory table in to two tables which having one to many
now suppose if you want to get the data like territory_No,territory_Location,territory_sales then you have to join two tables which is an overhead ,so in this case we do denormalization instead of joining of the tables/views etc
Denormalized territory table contains (territory_No,territory_Name,territory _Location,territory_Qtr1sales,territory_Qtr2sales,territory_Qtr3sales,territory_Qtr4sales );
Vasanthmvp, if this helps please login to Mark As Answer. | Alert Moderator