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.
Write down some of the differences between the data query and the knowledge query.
What is meant by the term merge?
Specify the System variables?
Describe briefly Aggregate transformation?
Which efficient data structure is used in RDBMS, for internal storage representation?
Specify the types of prompt in the Cognos?
Write down the differentiation between view and materialized view?
What demerits of ODBC does OLE DB overcome?
How do I set a password to be null?
Give a brief introduction of the term real time data-warehousing?
18,76,764
1938474 Asked
3,689
Active Tutors
1431521
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!