What is the difference between er modeling and dimensional modeling?
- 1 Answers
- 1233 Views
- I also Faced
- E-Mail Answers
Answer / Nitesh Kumar Singh
Entity Relationship (ER) modeling is a process used for conceptual schema design in database systems, focusing on entities, relationships, attributes, and cardinalities. It's used for logical database design as well. Dimensional modeling, on the other hand, is specifically designed for data warehousing purposes, aiming to optimize query performance by structuring data into fact tables (containing measurable values) and dimension tables (categorical attributes).
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Snow Flake Schema design in database?
What is the use of dimensional modeling in data warehousing?
What is the difference between view materialized view and view?
What is data warehosuing hierarchy?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
How can Oracle Materialized Views be used to speed up data warehouse queries?
What is the difference between narmal load and bulk load?
Can we have multiple application.cfm file in an application?
where exactly in dataware house a confirmed dimension can be created
Explain the difference between keylokup and joiner?
how much memory space occupied real time project (roughly)?
what is the difference between etl tool and olap tools
Teradata 
