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.
Write a short note on the differences between vertical and horizontal portioning?
Clarify how we can export mappings to production environment?
Briefly explain continuous and discrete data in data mining?
Specify different types of transformations available in the Informatica?
Explain the difference between expression and aggregator?
Describe how a scenario is employed for business rule?
Explain the term Cloud Computing?
What are some of the impediments to good decision making? Given the availability of copious information, why do good managers still make bad decision?
Illustrates the difference between a user’s defined function and a stored procedure?
Give a brief introduction of the term analysis service?
18,76,764
1939283 Asked
3,689
Active Tutors
1431715
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!