Top Articles

SQL Challenge: Tackling the Island Problem in Time Series Data

Jump into our SQL Challenge! Today, we’re exploring customer loyalty trends. Are you prepared to show off your SQL skills? About the quiz In this SQL pop quiz, we’re challenging you to demonstrate your understanding of islands in a time series data set. Whoever submits the correct and most performant query will be featured in …

Uli Bethke November 7, 2023

OUG Ireland BI Special Interest Group launched

At the OUG Ireland 2009 we launched the OUG Ireland Business Intelligence Special Interest Group. All OUG Ireland members are welcome to join. Tony Cassidy from Bearing Point and me…
Uli Bethke April 22, 2009

Query hints in OBIEE

I have recently come across a post on the OTN forums on how to use hints in OBIEE. OBIEE lets you specify hints in the physical layer on a table…
Uli Bethke April 5, 2009

Consuming a REST web service with Oracle

SOAP web services dominate in a SOA environment. However, there is a new kid on the block: REST. This is a more lightweight approach to exchange data over HTTP, which…
Uli Bethke March 12, 2009

It's the tool, stupid. Or is it?

Every couple of months or so, they run an article on Business Intelligence in one of the Sunday business papers here in Dublin. The tenor of these articles goes like…
Uli Bethke March 3, 2009
ETL,

Date dimension script with Oracle SQL

The script below will create a date dimension in just one SQL statement. We don't use performance-killer nonsense such as cursors, functions etc. We just pick a start date and…
Uli Bethke February 24, 2009

One pass SCD2 load: How to load a Slowly Changing Dimension Type 2 with one SQL Merge statement in Oracle

The other day I came across a useful new feature in the Merge statement for SQL Server 2008. This new feature outputs merged rows for further processing, something which up…
Uli Bethke February 1, 2009
spinner