• That sounds like it would work. Another possibility is to add each of the 5 keys to the dimension.

    Are you conforming the information from the different databatases that are for the same vendor, etc? For instance, if they provide different values for the same field (address, for example), are you resolving these discrepancies?