Both the lookup and slowly changing dimensions are good approaches. A third approach would be to use your destination as a data source, and then outer join the tables together....