Once something takes more than an hour to figure out, it is always a good candidate for a new blog post. This one definitely took longer than an hour.
I am supporting a data mart with compensation data for an international company. There is a currency dimension table that gets populated from a view in an operational database. The currency key is an IDENTITY column and gets populated with sequential values, starting at 1 with an increment of 1. Continue reading