Re: Uploading data for star schema

From: Steven Hauser <>
Date: 6 Dec 2000 17:44:16 -0600
Message-ID: <90mj0g$ijj$>


I usually run some cleaning scripts in perl or gawk before loading and doing all stuff in the database. Maybe dump tables and compare to the new data, filtering out trash. Maybe do some formatting.

Then use sql loader to shove it in to Oracle. And don't forget that sqlload will load good rows and skip bad rows as another filtering process.

Then when it is in Oracle you can beat on it even more with PL/SQL.


Steven Hauser email: URL:
Received on Thu Dec 07 2000 - 00:44:16 CET

Original text of this message