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.
Illustrates the term Monopolistic Competition?
List out the various detected patterns.
Describe truncate commands.
Define the term visual data mining.
Write down brief note on the issues for database performance?
Specify the use of data stage designer?
What do you understand by the term snapshot replication in DBMS?
Specify different types of transformations available in the Informatica?
Distinguish between the query answering and direct query answering.
Write down the some of the important security characteristics of a DBMS?
18,76,764
1945164 Asked
3,689
Active Tutors
1412786
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!