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.
What is Data Manipulation Language?
Explain the calculation contexts?
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
Write brief note on E.F. Codd, and why is he noteworthy in the development of modern database systems?
Explain the way to audit the SQL sent to the server.
List out the three kinds of business rules and also define each of them?
Illustrates each entry in the Link List called?
What does web mining mean
List out the different types of the data providers?
Explain the term Contexts?
18,76,764
1958892 Asked
3,689
Active Tutors
1420638
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!