InterviewSolution
Saved Bookmarks
| 1. |
Explain what you mean by a star schema in the context of data warehousing. |
|
Answer» Star schema is a sort of MULTIDIMENSIONAL model and is USED in a data warehouse. The fact tables and dimension tables are both contained in the star schema. There are fewer foreign-key JOINS in this design. With fact and dimension tables, this schema forms a star. |
|