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

Essential skills any BI Consultant should have. Or why a fool with a tool is still a fool.

Today I'm gonna be mean. Before we start though, here is my definition of a BI consultant. In my eyes, a BI consultant is the guy at the frontend of…
Uli Bethke June 26, 2009

Greenplum, MapReduce, and Hadoop

If your job involves processing massive amounts of data you should familiarize yourself with Greenplum, MapReduce, and Hadoop. With 6.5 Petabytes of data eBay runs the world's largest data warehouse…
Uli Bethke June 18, 2009

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

Developing a Knowledge Module in ODI published on OTN

My article Developing a Knowledge Module in Oracle Data Integrator was published on OTN yesterday. In the article I demonstrate how to implement best practices for loading a fact table…
Uli Bethke June 9, 2009

Troubleshooting ODI connectivity to SQL Server Express 2005

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and RecipesIt took me an hour or two today to connect to an…
Uli Bethke May 1, 2009

Executing Interfaces and Procedures in parallel in a Package with ODI

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and RecipesI have been working on Oracle Data Integrator (ODI) over the last…
Uli Bethke April 29, 2009
spinner