What is the difference between ER Modeling and Dimensional Modeling?

Question

What is the difference between ER Modeling and Dimensional Modeling?

1 Answer

Related questions

0 votes

Q: What are the types of Dimensional Modeling?

asked Oct 20, 2019 in Dataware house by rajeshsharma (23.9k points)

0 votes

Q: Define Dimensional Modeling?

asked Jun 5, 2021 in Informatica by rajeshsharma (23.9k points)

0 votes

Q: What is ER Diagram?

asked Oct 20, 2019 in Dataware house by rajeshsharma (23.9k points)

0 votes

Q: What is called Dimensional Modelling?

asked Oct 20, 2019 in Dataware house by rajeshsharma (23.9k points)

0 votes

Q: what is the difference between agile modeling and the agile manifesto

asked Feb 1, 2020 in Agile by rajeshsharma (23.9k points)

0 votes

Q: What is the difference between metadata and data dictionary?

asked Oct 20, 2019 in Dataware house by rajeshsharma (23.9k points)

0 votes

Q: What is the difference between Datawarehouse and OLAP?

asked Oct 20, 2019 in Dataware house by rajeshsharma (23.9k points)

0 votes

Q: What is the difference between View and Materialized View?

asked Oct 20, 2019 in Dataware house by rajeshsharma (23.9k points)

0 votes

Q: What is the difference between OLTP and OLAP?

asked Oct 20, 2019 in Dataware house by rajeshsharma (23.9k points)

+2 votes

Q: What are some differences in data modeling between Power BI Desktop and Power Pivot for Excel?

asked Jan 16 in PowerBI by Robin (14.6k points)

0 votes

Q: Which of the following step / assumption in regression modeling impacts the trade-off between under-fitting and over-fitting the most.

asked Dec 31, 2019 in Data Science by sharadyadav1986 (31.7k points)

0 votes

Q: DBMS Reduction of ER diagram to Table

asked Oct 27, 2019 in DBMS by rajeshsharma (23.9k points)

0 votes

Q: What is ER Diagram in DBMS?

asked Oct 27, 2019 in DBMS by rajeshsharma (23.9k points)

0 votes

Q: What is DBMS ER model?

asked Oct 27, 2019 in DBMS by rajeshsharma (23.9k points)

0 votes

Q: Suppose you are training a LSTM. You have a 10000 word vocabulary, and are using an LSTM with 100-dimensional activations a. What is the dimension of Γu at each time step?

asked Jul 19 in Deep Learning by SakshiSharma (32.2k points)

SakshiSharma · Answer 1 · 2019-10-20T07:47:19+0000

ER modeling will have logical and physical model but Dimensional modeling will have only Physical model.

ER Modeling is used for normalizing the OLTP database design whereas Dimensional Modeling is used for de-normalizing the ROLAP and MOLAP design.

What is the difference between ER Modeling and Dimensional Modeling?

Please log in or register to answer this question.

1 Answer

Related questions

Top Trending Technologies Questions and Answers

HOT LINKS

TRANDING TECHNOLOGIES

CONTACT US

Follow us on Social Media