Is there any reason that you can't define relationships between the two tables? You mentioned that the "fact table contains foreign keys related to my dimension tables" so you should be able to define the relationship and then use a join.