Cardinality of Rowsources

Sunday, June 21st, 2009 by Peter Scott

One of the things I sometimes come across when looking at legacy ETL code for data loading is the misuse of query hints to “improve” data load performance. Sometimes DBAs or developers do not remember that “tuning the select” may not be the same thing as “tuning the insert”; Jonathan Lewis wrote about an example […]

Dynamic SQL

Tuesday, May 26th, 2009 by Peter Scott

One of my pet hates is the inappropriate use of dynamic SQL within ETL processes, for example building a command as VARCHAR2 string then using it in an “execute immediate” statement. Putting commands into strings whether hard-coded ones within the package or procedure, retrieved from some ‘code’ table in the database or even built on-the-fly […]

Simple Steps to Sustainable ETL

Thursday, April 30th, 2009 by Peter Scott

Recently Stewart posted his first blog post here on the Rittman Mead Blog, it drew quite a bit of comment about using external techniques to the ETL to provide mechanisms to do things more efficiently or to do things that could not otherwise be done.
Notwithstanding the claims of some DW appliance vendors that you just […]

Sharing Prompts Between OBIEE Dashboards

Friday, April 10th, 2009 by Peter Scott

Occasionally I lurk over at the OTN Discussion Forums, and the Business Intelligence Suite Enterprise Edition one in particular.
Today I saw a question on passing a dashboard prompt value between dashboards and not knowing the answer I decided to spend an while (I have a day off to day) on coming up with a solution […]

Oracle Merge Is Not Just For Merging

Tuesday, March 31st, 2009 by Peter Scott

I have long liked the Oracle merge statement - so much more elegant (and efficient) than the “try insert and if it fails have a go at update” or “try update and if there is nothing to update add the row” strategies that used to be used. But did you know that you can (from […]

Website Design & Build: tymedia.co.uk