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, why we use the lookup transformations?
What do you mean by optimization and performance tuning and explain how does it actually work in the practical projects?
Explain the loops?
What the difference between sequential file stage and hashed file stage is in relates to DataStage Server?
Briefly describe the differentiation between data warehousing and data mining ?
Describe any two reasons which show the necessity of database redesign?
Describe the difference between complexType elements and simple elements?
State the steps for “this message could not delete” from the particular tables?
Explain what is meant by the repository and what does it consists of?
Write out the disadvantages of using the Alias?
18,76,764
1957832 Asked
3,689
Active Tutors
1436967
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!