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)

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 Releases Industry Data Models

By jean-pierre.dijcks on April 20, 2009 3:18 PM

There is a lot of interesting news coming out of Oracle these days... And while the sun is shining here in California there are interesting things going on. We just made the first in a series of industry data models...

Comments (2)

New External Table Functionality - PreProcessing and Data Pump

By jean-pierre.dijcks on February 25, 2009 9:00 AM

I'm not sure everyone is aware of the fact that you can use external tables these days to work with data pump export files. You can read in data using an external table, or you can unload data. For more...

Comments (0)