For databases with a large number of SITE records (n=100 or more), the 4.0 delivered BBDW_FACT_FINANCIALTRANSACTIONLINEITEMSITE.dtsx can take a very long time to complete when performing a Blackbaud Data Warehouse ETL refresh.
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch.
Steps to Duplicate
You can see if you are impacted by running the following query against your CRM (OLTP) database: