How do you handle many-to-many relationships in a dimensional data model? What is a bridge table and when do you need one?

Sample answer preview

Many-to-many relationships occur frequently in business data and require special handling in dimensional models. A single customer may belong to multiple segments. A single product may fall into multiple categories. A single doctor may have multiple specialties.