title: What are the advantages/disadvantages of having all Foreign Keys in the Fact Table?
body: <p>Our team is planning to add missing dimension keys (FK's) to our fact tables to allow for direct querying between our dimensions and fact tables rather than going through tables. Essentially, leaning more towards a star schema. This will improve querying performance (as less joins will be required).</p>
  
  <p>I have read online that Foreign Key (FK's) constraints will impact performance of insert, updates and deletes. </p>
  
  <p>Are there other things that we should consider?</p>