What is the main difference between schema in rdbms and schemas in datawarehouse?
- 1 Answers
- 1197 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Explain how to generate iqd file from framework manager?
What is the purpose of Dataware Control?
