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.
Define the term Smoothing.
States the term Global temporary.
Explain the various types of stages?
Illustrate out some of the standard Business Intelligence tools in the market?
What do you understand by the term cascading update in DBMS?
Illustrates the mobile enterprise application enablement?
What is the main reason that database is considered as "self-describing"?
Explain the Aggregator Transformation?
Explain the term transformer stage?
What do you understand by the term Dataset?
18,76,764
1937422 Asked
3,689
Active Tutors
1460289
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!