ETL in Oracle: the concept

From: geos <geos_at_nowhere.invalid>
Date: Fri, 21 Oct 2011 18:22:51 +0200
Message-ID: <j7s68v$mlv$>

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,

Received on Fri Oct 21 2011 - 11:22:51 CDT

Original text of this message