• When you fill the FACT Table, how you are making Source,

    Like a T_SQL staging table joining with dimensions to get the dimension id.

    or u r using Lookups? because there might be a case that, you are having problem when you fetch the data from the source.

    hopefully you might have implemented that but just for information you can also use Fast Load option. if you are using it then you can ignore this one :-).