What is the main difference between schema in rdbms and schemas in datawarehouse?
- 1 Answers
- 1195 Views
- I also Faced
- E-Mail Answers
Answer / Rajdeep Gupta
The main difference between a schema in Relational Database Management Systems (RDBMS) and a schema in Data Warehousing lies in their structure and purpose. An RDBMS schema typically groups tables, views, indexes, and other database objects by application or project, providing a logical organization for related data. A Data Warehouse schema, specifically a Star Schema, organizes data into facts (measures) and dimensions (qualitative characteristics), optimizing the structure for querying and reporting.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is META DATA information in Data warehousing projects?
Explain a relation schema and a relation?
What are the data marts?
What Oracle features can be used to optimize my Warehouse system?
Fact table is in normalized or de-normalized form?
What are the primary ways to store data in OLAP?
Explain what are fact, dimension, and measure?
Can we have multiple application.cfm file in an application?
What is critical column?
What is a relationship?
Explain when do we analyze the tables? How do we do it?
How to calculate fact table granularity?
Teradata 
