General Datawarehousing Question:

What is is a Star Schema?

General Datawarehousing Interview Question
General Datawarehousing Interview Question

Answer:

Star schema is a type of organising the tables such that we can retrieve the result from the database easily and fastly in the warehouse environment.Usually a star schema consists of one or more dimension tables around a fact table which looks like a star,so that it got its name.


Previous QuestionNext Question
Explain What are slowly changing dimensions?Explain Which columns go to the fact table and which columns go the dimension table?