Re: ETL in Oracle: the concept

From: Mladen Gogala <mgogala_at_no.address.invalid>
Date: Fri, 21 Oct 2011 18:13:56 +0000 (UTC)
Message-ID: <j7scp4$s51$4_at_solani.org>

On Fri, 21 Oct 2011 18:22:51 +0200, geos wrote:

> my first very general attempt is to:
> 1) create materialized view logs on source tables 2) develop procedures
> to populate data into dimension tables 3) develop procedures to load
> data into fact tables 4) run these procedures through scheduler
> (external or dbms_scheduler)

I would start by reading some relevant books and articles, just like Joel has recommended. You also may buy Informatica instead.

-- 
Harry Potter in 1D: --------------------------------------------

Received on Fri Oct 21 2011 - 13:13:56 CDT