Uploading data into star schema

From: <sw_at_weinerfamily.org>
Date: Wed, 06 Dec 2000 05:16:09 GMT
Message-ID: <3A2DCB6D.E4360F93@weinerfamily.org>

I have a textfile that contains rows of data in a non normalized fashion

What I need to do is load that data into a star schema nightly or weekly (automated).
In order to do this I need to load each of the dimension tables and get the
ids of the entry. Of course if the row already exists I need to just get

the ids. After I have done this on all measures (8 of them). I need to stuff the ids and other data into a new record in a fact table.

Currently, I am doing this using a VB program and it is incredibly slow.

Is there a way to do this using SQLLoader or some other technique that would
be more efficient?

NOTE - probably doesn't matter but I am not using Oracle OLAP.

Thank you. Received on Tue Dec 05 2000 - 23:16:09 CST