One of the most common questions we get asked is why the result set for a query (say from FACT_LOAN_ACCOUNT) is 100x what they expected.  The answer often is that a DIMID_PROCESS_DATE filter wasn't set or wasn't used during the join when it should have been.  If you get results that seem wildly off, be sure to check the process date first!