BI solutions that Blackbaud delivers are custom in nature.  If you do not have a DIM_Prospect table in the warehouse but do have a DIM_ConstituentProspect table, it's fine to change the package to indicate the correct prospect table.

Please contact Support with any questions regarding the BI solution in your environment.  A copy of the solution may be needed to tell for sure if this is a valid change for your environment.