Design a STAR schema

You are the data design specialist on the data warehouse project team for a retail company. Design a STAR schema to track the sales units and sales dollars with three dimension tables. Explain how you will decide to select and build four two-way aggregates.

Assume you are in the insurance business. Find two examples of type 2 slowly changing dimensions in that business. As an analyst on the project, write the specifications for applying the type 2 changes to the data warehouse with regard to the two examples.

Indicate if true or false:

A. Type 1 changes for slowly changing dimensions relate to correction of errors.

B. To apply type 3 changes of slowly changing dimensions, overwrite the attribute value in the dimension table row with the new value.

C. Large dimensions usually have multiple hierarchies.

D. The STAR schema is a normalized version of the snowflake schema.

E. Aggregates are precalculated summaries.

F. The percentage of sparsity of the base table tends to be higher than that of aggregate tables.

G. The fact tables of the STARS in a family share dimension tables.

H. Core and custom fact tables are useful for companies with several lines of service.

I. Conforming dimensions is not absolutely necessary in a data warehouse.

J. A value circle usually needs a family of STARS to support the business.

Solution: