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

Uli Bethke February 1, 2009

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 ...

Read More

Competitive Business Intelligence: web scraping with Oracle.

Uli Bethke January 6, 2009

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 ...

Read More

OWB Best Practice Part 1: Logically organise your DW project with Collections

Uli Bethke November 12, 2008

Once you have gone beyond the implementation of more than one data mart for your Enterprise Data Warehouse project in Oracle Warehouse Builder, it becomes harder and harder to find a particular object for editing amongst the hundreds or thousands of objects. OWB Collections come to the rescue. They allow you to logically organise your ...

Read More

CDC & Streams Performance Test

Uli Bethke November 11, 2008

Scenarios Objective of the Streams Performance Test was to identify risks and bottlenecks for CDC and Streams. The following items were of particular interest to us: Identify bottlenecks for batch jobs with a low commit frequency, i.e. transactions that modify large numbers of records without committing frequently. We needed to know this because we have ...

Read More
1 77 78 79 80