While loading data in Fact tables we usually see a scenario where the fact data is available but there is no corresponding business key in the related dimension. In this case we choose multiple options to resolve the issue. Ignore that fact Insert the associated business key in dimension table and return...