Re: Data Warehouse - Upload Time

Hi

Thanks for the info.

I have a small Data Warehouse, where in the Upload to the Temporary table takes place in few seconds for about 5,000 rows. But the dissemination of the records from the Temporary table to 5 other fact tables take about 15 minutes. Dynamic SQL (used as the fact table name is decided in run-time and a column's value is modified by a user-defined function) has been extensively used in the DISSENINATION process. I am afraid if it could take longer like 2 hours when it comes to 1 or 2 million records. Can anyone who has used Dynamic SQL in Data Warehouse, suggest if this is a right idea to continue with DYN SQL, or they should be changed to static SQLs. Moreover, i would like to know if 2 Hours time for COMPLETE UPLOAD ( for EXTERNAL DATA to get to the FACT TABLEs thru' TEMPORARY TABLE) of 1 Million records is NORMAL.

Would appreciate any suggestion in this regard! Thanks
Nandakumar

In article <01befb47$be8f1350$34947dc2_at_karpov>,   "Stephen Flinter" <sflinter_at_indigo.ie> wrote:
> Like so many things in life, the answer is it depends... on your
hardware
> (both for the Oracle instance, and more especially the disk set up).
>
> On the last warehouse project I worked on, we were able to upload 50
> million rows in <30 minutes. This was running Oracle 7.3.4 on Sequent
> Symmetry hardware (later upgraded to NUMAQ/2000), using striped EMC
disk
> arrays. All in all _very_ heavy hardware. However, if you have the
money
> to do it, you can certainly get exceptionally impressive upload times.
> Going from the above figures, getting >1 million rows per minute is
> definitely possible.
>
> Cheers,
>
> Steve
>
> Nandakumar <N.Kumar_at_rocketmail.com> wrote in article
> <7r6rn0$9rt$1_at_nnrp1.deja.com>...
> > Can someone tell me how much time it would take ( or is acceptable)
for
> > loading one million rows of data into a data warehouse, at its worst
> > performance?
> >
> > Thanks!
> > --
> > Nandakumar
> > (N.Kumar_at_rocketmail.com)
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
> >
>

--
Nandakumar
(N.Kumar_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 13 1999 - 10:08:13 CDT