What is the main difference between schema in RDBMS and schemas in DataWarehouse?
Submitted by: AdministratorRDBMS 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
* 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
Top Data Warehousing Basics Questions
☺ | Explain the definition of normalized and denormalized view and what are the differences between them? |
☺ | Explain degenerate dimension table? |
☺ | What is the main difference between schema in RDBMS and schemas in DataWarehouse? |
☺ | What are the Data Marts? |
☺ | Explain Differences between star and snowflake schemas? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |