title: How to handle Bridge table in Star Schema
body: <p>I am trying to build a star schema from an E/R diagram (OLTP system) that seems to contain a bridge table. Order is an obvious fact-table and product a dimension-table. I can't see how I can keep the bridge table if the model needs to be a star schema. How would you tackle this relationship if I need to keep information about Channel in the model?</p>
  
  <p><a href="https://i.stack.imgur.com/5L4LC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5L4LC.png" alt="enter image description here"></a></p>