title: How to create a data model for invoices in a large data warehouse?
body: <p>I am creating a data model for customer invoices in a large data warehouse.  </p>
  
  <p>The following shows the fields on a typical invoice:</p>
  
  <p><img src="https://i.stack.imgur.com/x7aPX.gif" alt="enter image description here"></p>
  
  <p><br>
  The following is the data model I worked out so far to model the invoices:</p>
  
  <p><img src="https://i.stack.imgur.com/7Oemj.png" alt="enter image description here"></p>
  
  <p>Conventional wisdom is that a large data warehouse should use a star schema, which means one fact table, but it seems that to model an invoice I would need <strong>two</strong> fact tables, as shown above.  Would it be correct to use two fact tables?</p>