Question: The dimensional model is built on a star-like schema or snowflake schema, with dimensions surrounding the fact table. To build the schema, the following four-step
The dimensional model is built on a star-like schema or snowflake schema, with dimensions surrounding the fact table. To build the schema, the following four-step design model is used: Select one or more: a. Choose the business process b. Declare the grain c. Identify the dimensions d. Identify the fact e. Optimize the fact process f. Increase the grain g. Equalize the model h. Identify the keys
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
