Re: ETL in Oracle: the concept

From: joel garry <>
Date: Fri, 21 Oct 2011 10:55:51 -0700 (PDT)
Message-ID: <>

On Oct 21, 9:22 am, geos <g..._at_nowhere.invalid> wrote:
> I wonder if you could you share some thoughts and experience about doing
> (small) ETL in sql/plsql? I mean what general approach would you take?
> what pracices do you think could be described as best practices?
> 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)
> what should I pay attention to? what should I be aware of? I mean not
> detailed explanation or design of database structures but general
> thoughts about the set up, metadata, general concept. I would also
> appreciate links to articles in the subject if any.
> thank you,
> geos
> --
> FUT:

I don't know what hair transplants have to do with Oracle, but please don't multipost or crosspost between the various parts of the hirearchy.

A quick google found

My own stuff is way out of date, so I won't answer.


-- is bogus.
Received on Fri Oct 21 2011 - 12:55:51 CDT

Original text of this message