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 the difference between sequential file stage and hashed file stage is in relates to DataStage Server?
Elucidate what are the tasks which Load manger process will do?
What do you understand by the term Relationships in DBMS?
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
What is the budget analysis from aircraft solutions?
Write a short note on the differences between vertical and horizontal portioning?
Specify the types of connections we use while connecting with the database?
Describe briefly the term maximum and minimum cardinality?
Illustrates the purposes of a key component in SQL Server Integration Services (SSIS)?
Give a brief introduction of the term data cleaning?
18,76,764
1958759 Asked
3,689
Active Tutors
1458894
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!