and 3 others joined a min ago.
0
3.4kviews
Why is entity relationship modeling technique not suitable for the data warehouse? How is dimensional modeling different?
1 Answer
0
817views
written 2.0 years ago by
pradnyanabar2613
★ 5.1k
|
• modified 2.0 years ago |
- Dimensional Modeling (DM) is a data structure technique optimized for data storage in a Data Warehouse.
- The purpose of dimensional modeling is to optimize the database for faster retrieval of data. The concept of Dimensional Modelling was developed by Ralph Kimball and consists of "fact" and "dimension" tables
- Dimensional table …
and 2 others joined a min ago.
ADD COMMENT
EDIT
Please log in to add an answer.