Choose the correct four steps involved with dimensional modeling technique of designing the a model. Choosing incorrect items will reduce your mark.

Details

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