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.



Discussion

No Comment Found