Lead Data Scientist Question:

Please explain star schema?

Lead Data Scientist Interview Question
Lead Data Scientist Interview Question

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.


Previous QuestionNext Question
Can you write the syntax to set the path for a current working directory in R environment?Do you know what are Recommender Systems?