Hi,

I need some advise. We are in he process of designing our first data
mart. This Datamart will consists of sales orders activity. Sales
orders have lines created, deleted and inserted on a daily basis as
long as the sales order is open.

It has been suggested that we do triggers the these tables and then
populate the Datamart. Which the DBA is not thrilled with. is there
another way to do this wihtout triggers.?

The data needs to get updated daily and the volume is about 500K rows.
The data is being sourced from an ERP and the DB is oracle 9i. We also
have the option of using SQL Server if need be. Our BI tool is Cognos
and ETL tool is not an option since our data tranformations are very
simple.

Please share your experience.

Regards
Ather

Well,

I have had a great deal of success using PL/SQL or T-SQL code to generate
tables that can be exported using SQLoader (Oracle) or DTS (SQL 2000).

If you would like some examples, let me know.

John Smith

<athermian (AT) yahoo (DOT) com> wrote

Usually, I prefer to extract data for population into a data mart
through a batch sql process. In the case of Oracle that would
typically be run via sqlplus. Then run sqlplus along with those
queries from a simple shell (like bash), or an interpreted language
(like python, ruby, or perl).

This is very easy to manage, schedule, rerun, etc.

buck