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.
Describes the difference between NULL and VOID pointers into Data Structures?
Elucidate Where to keep informatica rejected data? How to remove the informatica rejected data?
State the use of data stage jobs?
What is meant by the fact table?
What are the differences between perfect competition and Monopoly?
How does one get the correct binary value?
Define the RETURN statement.
Justify whether all the Business Objects users build the data providers?
Write down the some of the important security characteristics of a DBMS?
Elucidate what are the basic requirements to join two sources in the source qualifier?
18,76,764
1924870 Asked
3,689
Active Tutors
1454231
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!