This is not a question but an observation based on what I experienced. I am in US Central time zone and my initial attempts to use the dimDate dimension tied to the Loads was not working. I ended up adding adding a new column called LoanStartDateAsDate that got rid of the time value associated with the loan record. I removed the recommended [Loan Start Date] mapping and remapped to my derived LoanStartDateAsDate column. This fixed the mismatch based on the time.