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.
Explain what is meant by the term universe stage?
Define the explaining plan and how is this used?
Illustrates the way to assign an address to an element of a pointer array? Answer: We can assign a memory address to an element of an array of pointers by usin
Explain and compare OBE and SQL?
Illustrates the term data sparsity and how this effect upon aggregation?
Explain offline /online modes in the Designer?
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
Explain the difference between ARRAY and STACK in Data Structures?
Specify some of the areas where the data warehouses are utilized in the present and in the future?
Determine the best value for cschedspins?
18,76,764
1958624 Asked
3,689
Active Tutors
1427605
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!