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

Uli Bethke DW Design, ETL, 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 until now (Oracle 11.1.0.7) is not possible in Oracle. This extra functionality can be used to load a Slowly Changing Dimension Type 2 in one SQL statement. As a result ...

Star transformation in snowflaked schema with compound keys

Uli Bethke Oracle

This article builds on Mark Rittman's recent post on explain plans for star transformation. Every now and again I have come across claims that the CBO only uses star transformation with single part foreign keys on the fact table: "In order for a RDBMS query optimizer to execute a query using a Star Transformation, a single part foreign key with ...

Competitive Business Intelligence: web scraping with Oracle.

Uli Bethke Business Intelligence, Web Mining

In my opinion, one of the trends for Business Intelligence in 2009 (and the years to come) will be the integration of externally available data (data not found within the organisation itself, e.g. data in magazines, the web, libraries etc.) into the data warehouse and into an organisation’s business processes. Using BI to monitor the external environment that an organisation ...

Make a difference to your bottom line with BI

Uli Bethke Business Intelligence

Get it from Amazon.com Get it from Amazon.co.uk In the first two chapters the authors develop their core argument. BI projects are only successful when they have a positive impact on the bottom line of an organisation. BI so the central and simple theme of the authors, needs to give an organisation competitive advantage by either increasing its profits or ...