Lead Data Scientist Question:
Download Questions PDF

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.

Download Lead Data Scientist Interview Questions And Answers PDF

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?