data warehouse load question

Hi Guru's,

What is the best way to load data to datawarehouse from the source system?

Simply ,

   1 . select data from source system to fılesystem    2 . load data from file system to the warehouse database  

Is there any binary unload-load option ? (Like informix - Hpl) How can i guarantee all this operations ? (If one fails - do that load again )

I am about the design my sysem for all these things but i will be appreciated if anyone can share experience with me before i reinvent the wheel .

Kind Regards,
hope Received on Thu Aug 07 2003 - 07:50:25 CDT