Need to bring in some additional rows into the Fact table from another source. Some of the rows are common but I need to add only those that are not present in FACT currently. But rows should be entered based on 2 out 3 common fields. For example, I need to match SalesPersonID and ProdName only, even though Category also happens to be a common field.
Understand, but I need joining based on two fields not three. From my original post:
"But rows should be entered based on 2 out 3 common fields. For example, I need to match SalesPersonID and ProdName only, even though Category also happens to be a common field."
