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.
When two relational tables is connected to SQ Trans, what are the probable errors it will be thrown?
Provide a brief introduction of the term cubes?
Write down the latest error handling technique in SQL Server 2005?
Explain what is meant by the term catalog and its types in the cagonos?
Explain the user objects?
Give a brief introduction of the term surrogate key?
What is Redundant Array of Inexpensive Disks and what are various types of RAID configurations?
Illustrates the Delete commands.
Name four applications which are employing for triggers in DBMS?
Explain the operations that can be done with the Data Stage Director?
18,76,764
1929830 Asked
3,689
Active Tutors
1416941
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!