The Data Warehouse Insider

A follow up on "why does ETL take so long"

By jean-pierre.dijcks on July 27, 2009 12:04 PM

I got this comment from Oliver on the ETL posting: "in my opinion coding or modelling the etl-process is not the most time consuming part of building a data warehouse. The most time is spent on consolidating the dimensions and...

Comments (0)

Why does it take forever to build ETL processes?

By jean-pierre.dijcks on July 24, 2009 5:53 PM

One of the discussion topics at ODTUG was whether or not ETL (or better data integration) still makes up 70% of the DW development time. At that session my answer was YES. For some more context take a quick look...

Comments (5)

What is going on in the BI/DW world?

By jean-pierre.dijcks on June 23, 2009 6:57 PM

Well, lots of fun things as I got to experience in the BI/DW panel at ODTUG. There were some interesting questions from both the audience and Mark (Rittman that is…). The folks on the panel were Michael Armstrong-Smith, Mike Durran...

Comments (0)

Unloading data using External Table and Data Pump

By jean-pierre.dijcks on June 9, 2009 1:59 PM

Just for being complete and to update people on a minor detail, here is a quick example of a data pump driven External Table. SQL> CREATE TABLE EMP_50 2 ORGANIZATION EXTERNAL 3 ( TYPE oracle_datapump 4 DEFAULT DIRECTORY dmp_dir 5...

Comments (2)

More on Total Recall for the DW - Use "AS OF" to publish data

By jean-pierre.dijcks on May 18, 2009 9:12 AM

After writing the post on the ETL part I was talking to folks over here and we discussed some other interesting aspects of using time windows and "AS OF" query patterns with ETL like scenarios. The scenario goes a little...

Comments (0)

Total Recall for Data Warehousing

By jean-pierre.dijcks on May 12, 2009 2:28 PM

First of all, this is not a recall notice for your data warehouse...! This is one of those cool features that come with Oracle 11g that I think is usable in a different context (e.g. Data Warehousing). The first thing...

Comments (1)

Oracle at TDWI Las Vegas

By jean-pierre.dijcks on February 23, 2009 8:35 AM

The TDWI Winter conference has just started. Oracle is one of the premier data warehouse vendors at the show. This time around we are demonstrating: - HP Oracle Database Machine and the Exadata Storage Servers - Data Warehousing with Oracle...

Comments (0)