DW-- Long hours for minimum incremental data
Hi
One of our client is having an DW environment, where
300mb of weekly incremental data is applied every week to the
Data warehousing environment.
They do the below steps,
Download the data which is in the form of Dump.
ETL,(17 procedures are running) which is running for 35 hours.
( The experts of the project who were supporting this told
the time taken is correct, but we doubt.)
Cube building --RUnning for 12 hours.
Every week they are doing the above procedure.
Database -- Oracle 8i.
Since We are new to data warehousing environment and we
were asked to look into this, we need advices from experts
about the job running for long hours. We think they are doing
the entire rebuilding instead of applying the incremental data
into the required format.
I am sure that I will get immediate reply from Slimdave / Tamil..if they available.
Thanks