Data Load -- sql server data warehouse

oj
4/13/2004 10:52:23 AM

If 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

[quoted text, click to view]

MS User
4/13/2004 11:37:23 AM

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

sql server data warehouse : Data Load