http://blogs.technet.com/b/andrew/archive/2007/08/21/slowly-changing-dimensions-and-surrogate-keys.aspxYou would expect there to be a record and hopefully only one record for each sales person in a typical sales system and another record in another table for each of the customers. But what happens when a one of these sales people gets assigned to a differenten-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/andrew/archive/2007/08/21/slowly-changing-dimensions-and-surrogate-keys.aspx#3208599Tue, 03 Mar 2009 10:36:34 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3208599Andrew Fryer's Blog<p>Many resources on data warehousing talk about slowly changing dimensions and how to deal with them but</p> <img src="http://blogs.technet.com/aggbug.aspx?PostID=3208599" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2007/08/21/slowly-changing-dimensions-and-surrogate-keys.aspx#3155106Mon, 17 Nov 2008 11:37:56 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3155106Andrew Fryer's Blog<p>As I have remarked before Business isn’t run by the IT Department it is run by the people who hire and</p> <img src="http://blogs.technet.com/aggbug.aspx?PostID=3155106" width="1" height="1">