Sorry, but I'm not following that at all. As I've said, we might be at the limits of being able to help without actually seeing the item and there could still be something I'm missing. But I have never seen in an SCD1 dimension the same dimension name having multiple surrogate keys. I'm assuming it's an SCD1 as you haven't mentioned anything about the need to provide history. It this is a fact table keying issue, you will need to have the fact table produce its own otherwise meaningless key.