Playing with DATE ranges

If you search on the net for a trick to generate date rangees in Oracle, you most probably will end up here: variuos interesting and mind-challenging ways to achieve the same result. I found this way the most cost effective and readable, yet flexible enough for my datawarehouse ETL processes. WITH LIMITS AS (SELECTRead More

Chapter 2 – The Oracle VALUES table

An article I’ve read time ago gave me the idea to attach an extra table to manage the variable number of columns in different data sets*. This article about dimensional modeling was introducing the concept of “helper table”. In few words, I can create a single column and store a reference (a code, an ID) to another table which holds the real dimensions, no matter how many columns they are. I simply need to create a fake code for the dimension group and link the two tables on that code.