I am trying to poupulate a fact table. The fact table contains foreign keys realted to my dimension tables. I want to move the contents of my dimensions table to a temp table which will then allow me to populate the fact table. Unforunately, I cannot use join or union as the dimension tables do not have any relationships.

Can anyone help or have i got the wrong end of the stick ?