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.
Specify the types of dimensions which are available in the Informatica?
What is meant by the Surrogate key?
Briefly explain the batch processing in Business Objects?
Specify the types of connections we use while connecting with the database?
State the steps for “this message could not delete” from the particular tables?
Briefly describe the differentiation between Data warehousing and Business Intelligence?
Explain some of the reasons which someone familiar with Microsoft Access will desire to learn VBA?
Illustrates architecture of reporting services?
Explain the function of metadata for the three-layer architecture?
Explain the way to select tables for partition in Sybase?
18,76,764
1951615 Asked
3,689
Active Tutors
1447682
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!