What is the difference between er modeling and dimensional modeling?
- 1 Answers
- 1232 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain how to generate iqd file from framework manager?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is the purpose of Dataware Control?
