title: Dimension row with multiple attributes
body: <p>This isn't exactly what I am doing but I feel this is a good example:</p>
  
  <p>Let's say I have a Product dimension table that connects to my ProductSales Fact table. Each row in dimProduct holds all the relevant data for a single product (code, name, description etc) and there are around a million products.</p>
  
  <p>I now have a requirement to store the product categories into the warehouse. Each Product has multiple categories, averaging at 5. </p>
  
  <p>Am I supposed to duplicate entire rows in the Product Dimension for each category the product fits into or am I supposed to snowflake my current star schema with a dimCategory dimension and dimProductCategory link table between the two? </p>
  
  <p>I'm afraid that if I do the former then my Dimension table will become over 5 times bigger and if I do the latter then the model will become far more complex.</p>