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.
Explain the term operational data stage (ODS) and data warehouse?
Provide a brief introduction on the term Star Schema?
Explain for what the Supervisor module is used?
Illustrate briefly the term SQL sub query?
Identify those statements are true about a foreign key?
Explain the linked universes?
Explain Batches and Session?
Provide the formula for the Pearson’s r.
Write down the some of the important security characteristics of a DBMS?
Explain about Server Job and Parallel Jobs?
18,76,764
1922480 Asked
3,689
Active Tutors
1445191
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!