Denormalization of dimension tables in InfoCube in SAP BW

Note that In Data Warehouse, data load is less frequent as compared to data read. If you use normalized tables that result more number of joins and hence when you run multiple read statements on DW system, it effects the performance considerably.

When you are not using normalized tables, the response time of queries are improved however load time and memory space is increased.

You can refer below link to get advantages of denormalization in database and comparison with normalized tables.

http://searchdatamanagement.techtarget.com/definition/denormalization

Rishi Raj

Updated on 06-Dec-2019 06:54:17

• Related Questions & Answers
• Using fact and dimension tables in SAP HANA Modeling
• Demo version of SAP BW
• Embedded BW parameters for SAP HANA
• Retrieving ABAP BAdi from SAP BW
• Difference between SAP ECC system and SAP BW system?
• Unloading tables in SAP HANA database
• Disadvantages of using row based tables in SAP HANA
• Advantages of using Column based tables in SAP HANA
• Difference between Normalization and Denormalization
• Using SSIS to load data from SQL Server to SAP BW
• How to join tables in SAP system
• Getting information from pooled tables in SAP system
• Fetching data from transparent tables in SAP system
• Checking all tables and schema in SAP HANA
• Tables for generated Time data in SAP HANA