- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- 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 Articles
- 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
- Using SSIS to load data from SQL Server to SAP BW
- How to join tables in SAP system
- Creating Index in Column based tables in SAP HANA
- Checking tables in a schema in SAP HANA database
- Fetching data from transparent tables in SAP system
- Getting information from pooled tables in SAP system
- Checking all tables and schema in SAP HANA

Advertisements