title: How to solve this? Use a bridge table?
body: <p>I am designing a star schema and come across this problem. I have two dimension table - a Product (Key = Product Id) and a Customer (Key = Customer Id). In another table there are three fields - Business Unit, Product Id and Customer Id.In this table one Product id refers to many Business Units and many Customer Ids. My question is do i need to place the third table as a bridge table between Product Dim and Customer Dim? Or what should be a better way to solve this?</p>
  
  <hr>
  
  <h2>Product Dim</h2>
  
  <p>Product ID
  Product Name
  ....
  ....etc</p>
  
  <hr>
  
  <h2>Customer_Dim</h2>
  
  <p>Customer_Id
  Customer Name
  Customer Type
  .....etc</p>
  
  <hr>
  
  <h2>Third Table</h2>
  
  <p>Business Unit
  Product ID
  Customer ID
  .....etc</p>
  
  <p>Right now i created the third table as Bridge table and joined with Product and Customer Dim. The third table will have Product_id and Customer_id as FKs and Business Unit as the attribute.
  Is this the right approach?</p>
  
  <p>Thanks,
  Arun</p>