Hi,
The book says that when implementing a OLAP system, we have to go
though the ETL process and might need some tool to do this.
However, my company doesn't use any tool and I write a stored
procedures for this.I found that I can skip the ETL process and load
the code directly into the fact and dimension tables.

Is this ok? will there be anything wrong with my process?

my supervisor wants to go real time. I think I can use replication and
triggers to give him the solution.
what do you think of this?

thanks

K.

You need to look up the new UDM features in SQL 2005.

"SQL Ken" <SQLken (AT) gmail (DOT) com> wrote

The wrong thing is that you save 1 today to pay 2 or 3 tomorrow.
The only real reason to do that is realtime, but anyway you have to
consider that in the long term you will have higher costs, not lower.

Marco Russo
http://www.sqlbi.eu
http://www.sqkjunkies.com/weblog/sqlbi

SQL Ken wrote:

Hi,

If you want to see a fast and easy way for SSAS2000 / SSAS2005 visit
www.wherescape.com and download a trial and with the RAD tool for
Datawarehousing + OLAP you can handle all you need.

Regards, Marco
www.gmsbv.nl


SQL Ken schreef: