Prune Days on an E-Business Suite Source Environment
Prune days… often misunderstood, often just left “as default”. Possibly not helped by the fact that entering the search term …
Star Transformations with Bitmap Indexes
One area of data warehousing that often confuses people (typically those who have come from an OLTP development background) is …
SQL and PL/SQL Mistakes, Misunderstandings and Misconceptions – Part 1
I wasn’t too sure of what title to use for this blog post. I wanted to share some things that …
Aggregation Based on Dimensions in OBIEE
The Business Model in OBIEE allows for measures to be aggregated using a variety of different functions. For most scenarios …
External Tables from Shell Scripts
Here’s a little example of something I found quite interesting, and which you generally don’t see being used every day… …