Skip to content
Archive of posts tagged DW

Five Tuning Tips For Your Data Warehouse – A Presentation

I’d just realised that I hadn’t put the final draft of this presentation that I gave at the UKOUG BIRT SIG in January on the web – it’s now available here. If you don’t know Mark Rittman the “humour” at the beginning might go over your head – I guess you just had to be [...]

SCD2′s and their affect on the CBO

We’ve got lots of SCD2 type tables in our warehouse and I’ve been wondering about how much affect it has on the CBO. Essentially, my concern is that when you query an SCD2 you generally look for records as they were on a specific date – the analysis date as we call it. You end [...]