Interviewer And Interviewee Guide

Data Warehousing Basics Interview Question:

What is the main difference between schema in RDBMS and schemas in DataWarehouse?

Submitted by: Administrator
RDBMS Schema
* Used for OLTP systems
* Traditional and old schema
* Normalized
* Difficult to understand and navigate
* Cannot solve extract and complex problems
* Poorly modelled

DWH Schema
* Used for OLAP systems
* New generation schema
* De Normalized
* Easy to understand and navigate
* Extract and complex problems can be easily solved
* Very good model
Submitted by: Administrator

Read Online Data Warehousing Basics Job Interview Questions And Answers
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.