I thought this worth talking about as I’ve been in discussions with a number of people recently around best practices for data types etc.…
Read more →It is quite common for warehouse developers to customise standard processes to add additional fields. Ideally this is done by modifying the appropriate mapping(s)…
Read more →One thing I find interesting to explore is the integration of different tools with Oracle which may not always be obvious. For example, take…
Read more →Generating Rows Automatically in Oracle Quite often there is a need to generate rows in SQL. Whether it be to generate a row for…
Read more →If you missed part 1 then you can find it here. In this post I’ll be focussing on a somewhat common theme – indexes. Whilst this…
Read more →One area of data warehousing that often confuses people (typically those who have come from an OLTP development background) is bitmap indexes… why do…
Read more →I wasn’t too sure of what title to use for this blog post. I wanted to share some things that I see quite regularly…
Read more →