Data Load

SQL 2K
We have a data-warehouse server which loads data from different databases
which resides in a different server, perform business logic and load into a
FACT table.
I created 4 SQL jobs which does the above same thing from different
databases and writing to same table.
This job is scheduled to run at the same time.
My question
1) What all steps to consider ,since different jobs loading data to same
table and also query same table.
Thanks
ShIf each job has to do a look in the target table, it's probably not a good
thing to process them in parallel. Perhaps, you want to load the data
independently into a staging table for each of your jobs. Then do a final
push/pull of all staging tables.
-oj
http://www.rac4sql.net
"MS User" <sqlman@.sql.com> wrote in message
news:OdhPaWXIEHA.4052@.TK2MSFTNGP12.phx.gbl...
> SQL 2K
> We have a data-warehouse server which loads data from different databases
> which resides in a different server, perform business logic and load into
a
> FACT table.
> I created 4 SQL jobs which does the above same thing from different
> databases and writing to same table.
> This job is scheduled to run at the same time.
> My question
> 1) What all steps to consider ,since different jobs loading data to same
> table and also query same table.
> Thanks
> Sh
>