Differentiation between Dimensional Modeling and ER Modeling
Give a brief differentiation between Dimensional Modeling and ER Modeling?
Expert
Dimensional modeling is extremely flexible for the user viewpoint. Dimensional data model is mapped for making schemas. Whereas, ER Model is not mapped for making schemas and doesn’t employ in conversion of normalization of data into demoralized forms.
ER Model is employed for OLTP databases which utilizes any of the first or second or third normal forms, where as dimensional data model is used for data warehousing and uses third normal form.
ER model holds normalized data whereas Dimensional model holds denormalized data.
List out the various schemas which are supported by the BO Designer?
Explain the linked universes?
Explain the master/detail reports?
Write down a short note on XML and also describe the uses of it?
Give a brief introduction of the term dicing and slicing in business objects?
Name the methods and types of Collision Resolution Techniques used in each of the type?
Describes the difference between NULL and VOID pointers into Data Structures?
To implement the priority queue what is the minimum number of queues we need?
Define the efficient data structure used within the internal storage representation in RDBMS?
Explain the security aspects of stored procedures.
18,76,764
1934316 Asked
3,689
Active Tutors
1432923
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!