Thomas Kejser a SQL Server Regional Director has recently made several great posts about
Transforming Source Keys to Real Keys Part1
Transforming Source Keys to Real Keys – Part 2
fixing Zombie and Dolly keys !
It is a good approach to starting with Master Data Manangement.
His Physically Placing the Maps in the Architecture post brings it altogether.
Garrett Edmondson 