Differentiation between Dimensional Modeling and ER Modeling
Give a brief differentiation between Dimensional Modeling and ER Modeling?
Expert
Dimensional modeling is extremely flexible for the user viewpoint. Dimensional data model is mapped for making schemas. Whereas, ER Model is not mapped for making schemas and doesn’t employ in conversion of normalization of data into demoralized forms.
ER Model is employed for OLTP databases which utilizes any of the first or second or third normal forms, where as dimensional data model is used for data warehousing and uses third normal form.
ER model holds normalized data whereas Dimensional model holds denormalized data.
Briefly explain SQL Server 2005 Business Intelligence components?
Illustrates the definition of Economics?
Write about the term Data stage architecture?
Describe the some drawbacks of a standard language like SQL?
Explain about the Data Storage Definition Language?
Describe the reserving of memory using a declaration statement in data structure?
Is it possible that Table Partitioning Require User-Defined Segments in the Sybase?
State the difference between OLTP and OLAP?
Differentiate between Multiload and Fastload in terms of Performance?
Illustrates the difference between a file server and database server?
18,76,764
1960102 Asked
3,689
Active Tutors
1435152
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!