SQL & PL/SQL

Hi,

I'm loading data into my fact table having partitions on by date for everyday with local indexes. What we are doing we disable the index before we loading and we are enabling indexes after load. If we want load the data into multiple days disable and enabling taking lot of time. Is there any way that we can achieve this.

or

What is the best approach for the data loading in datawarehousing environment?

Please advice.

Thanks in advance,
Ramana.