title: FactLoanVolume - One or Many Fact Tables
body: <p>I am designing a Fact table to report on loan volume.  The grain is one row per loan transaction.  A loan has a few major milestones that we report on:  In order of sequence, these are Lock Volume, Loan Funding Volume and Loan Sales Volume.</p>
  
  <p>I have Lock Date, Loan Funding Date and Loan Sale Date as FK (there are other dimensions in addition to these) in the Fact table to role playing dimensions off my DimDate table.</p>
  
  <p>My question is, should I create separate Fact Tables to report volume for each major milestone or should I keep all of this in one Fact Table and use a "far in the future" date (e.g., 12/31/2099) for a milestone on a loan that has not been met?</p>
  
  <p>I have read the Kimball books but I didn't find a definitive answer(if one even exists).</p>
  
  <p>Thanks</p>