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: comp.databases.oracle.misc

On Oct 21, 9:22*am, geos <g... (AT) nowhere (DOT) invalid> wrote:
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
comp.databases.oracle hirearchy.

A quick google found
http://blogs.oracle.com/warehousebui... nkedin_group
http://oraclesponge.wordpress.com/20...t-performance/
http://nbrightside.com/blog/2006/02/...etl-for-oracle

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

jg
--
@home.com is bogus.
http://web.signonsandiego.com/news/2...radio-service/

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

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: --------------------------------------------