Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
ETL,

Oracle Data Integrator vs. Oracle Warehouse Builder: What to do, what to do?

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes One of the questions that regularly comes up in the forums,…
Uli Bethke July 13, 2009
Amazon EC2,

Oracle on Windows in the EC2 cloud. Persist computer name across instance shutdown.

For various reasons it is important that your Windows computer name persists across instance shutdown on EC2 (listener, tnsnames.ora, loopback adapter etc.).To achieve this you need to perform the following…
Uli Bethke June 17, 2009
Oracle,

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
Oracle,

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
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
DW Design,

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