Re: Data Load
From: oj (nospam_ojngo_at_home.com)
Date: 04/13/04
- Next message: Paul Atkinson: "Re: Huge differential backups"
- Previous message: Aaron Bertrand [MVP]: "Re: char vs int"
- In reply to: MS User: "Data Load"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 13 Apr 2004 10:52:23 -0700
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 "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 > >
- Next message: Paul Atkinson: "Re: Huge differential backups"
- Previous message: Aaron Bertrand [MVP]: "Re: char vs int"
- In reply to: MS User: "Data Load"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
