This article by Margy Ross & Ralph Kimball (found on Mark Rittman’s blog) provides some good discussion on common criticism’s of dimensional modelling. Reading it makes me reflect on the challenges in our warehouse and how we’ve probably fallen into a few of the traps they mention. Most of ours come back to not doing […]
We’ve used the analytic functions heavily in our data warehouse for a while now to do all sorts of rollup calculations, but I just ran into an interesting use for them in our operational system that I thought I’d pass along.
We were producing a file of invoice information to be sent to another system […]
OK, I’ve finally decided that it’s time to stop lurking around and start becoming an active part of the community. I’ve been an active blog reader for about a year now, but I’ve rarely commented. I’ve just been searching around for the tidbits of information I needed rarely sticking my head up.
So, hopefully that’s going […]