Re: Uploading data for star schema

yah,

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: hause011_at_tc.umn.edu   URL: http://www.sofbot.com/


---------------------------------------------------------