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.
Illustrates the term explain and how does this work?
Explain the term Chasm trap?
Describe the inconsistent values problem? Comprise an appropriate example?
When two relational tables is connected to SQ Trans, what are the probable errors it will be thrown?
Name the methods that are available in storing sequential files?
Explain some of the ETL Tools?
Give a brief note on the term degenerate dimension table?
Explain what is meant by the term catalog and its types in the cagonos?
Describe briefly the difference between a shared lock and an exclusive lock?
Describe briefly the alternative terminology which is employed in the relational model?
18,76,764
1948901 Asked
3,689
Active Tutors
1456986
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!