When is it absolutely necessary to denormalize the data?

Question

Hi How is it done and when should it be done and how does it affect the data base?

Subhendu De · Answer

Hi Suma There are couple of scenarios where we can use denormalize data Reporting Purpose specially in OLAP database where data retrieval could be more faster if we use denormalized data. OLAP database is generally used for analytical purpose and filled up by OLTP database. NoSQL which stores data in denormalized way. It again based on your requirement and volume of data to process.

Suma M · Answer

Subhendu De Thanks a lot