

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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
- 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
Advertisements