ER Modeling and Dimensional Modeling
Specify the difference between the ER Modeling and Dimensional Modeling?
Expert
a) ER Modeling is used in order to normalize the OLTP database design.
b) Dimesional modeling is used in order to de-normalize the ROLAP / MOLAP design.
Name the areas where data structures are applied broadly?
Clarify briefly why dimension tables is de-normalized in the nature?
What is the repository?
Differentiate between start schma and Fsldm?
Contrast a fat and a thin client?
Explain the designer objects?
Write a brief note on the differences between a data warehouse and data mart?
Write about the term metadata in brief.
Explain the procedure through which an end-user can share user objects with other users?
States the term Mirror Activator Disk mirroring?
18,76,764
1926495 Asked
3,689
Active Tutors
1421061
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!