Question

You are the data design specialist on the data warehouse project team for a manufacturing company. Design a STAR schema to track the production quantities. Production quantities are normally analyzed along the business dimensions of product,
time, parts used, production facility, and production run. State your assumption

Answer 1

Answer:

Star schema is one of the most important data warehouse

schemas. It is used to make decision making easier. We can use this schema representation to run simple queries on the data to get the desired outputs. The fact table is connected to the dimension table by using a foreign key. For example, we can use the time dimension table to get the sales in a particular quarter of the year. This will be helpful in predicting the next quarter sales.

THANKS