Data Scientist Question:

What is star schema?

Tweet Share WhatsApp

Answer:

It is a traditional database schema with a central table. Satellite tables map IDs to physical names or descriptions and can be connected to the central fact table using the ID fields; these tables are known as lookup tables and are principally useful in real-time applications, as they save a lot of memory. Sometimes star schemas involve several layers of summarization to recover information faster.

Download Data Scientist PDF Read All 55 Data Scientist Questions
Previous QuestionNext Question
Explain me what tools or devices help you succeed in your role as a data scientist?Tell me is rotation necessary in PCA? If yes, Why? What will happen if you don’t rotate the components?