medium10 pts · first answer countsdata-modellingdimensional-modelling

Many small flags on a fact

An orders fact has is_gift, is_express, payment_type and channel, each with only a few values. Adding each as its own dimension clutters the model. What is the usual design?

A.Store each flag as a separate fact tableB.Put the flags in the customer dimensionC.Combine them into one junk dimensionD.Drop the flags from the warehouse

Discussion 0

Join free to post in the discussion.

Many small flags on a fact

Discussion 0

Related questions