Check the Process Date
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 ...