Re: Data Load

From: oj (nospam_ojngo_at_home.com)
Date: 04/13/04

  • Next message: Cesar Luna: "Semiadditive dimensions / measures" 
    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: Cesar Luna: "Semiadditive dimensions / measures"

    Relevant Pages

    • Re: weird save-entropy behaviour
      ... On Sunday 15 November 2009 17:30:02 Ed Jobs wrote: ... The shells were not responding and the load was insane, ... So i know that it's the save-entropy cron job, ... Did the operator uid change or perhaps shared with another uid? ...
      (freebsd-questions)
    • Re: How to enqueue a number of video encoding jobs (vob to xvid or divx)
      ... I'm looking for a way to enqueue a number of video encoding jobs. ... When processing several, I load in the first Vob/mpg file, choose the ...
      (uk.comp.os.linux)
    • Change server, maintain the users.....
      ... All databases and jobs will be transfered to the new server. ... I will not load the old masterdatabase into the new server. ...
      (microsoft.public.sqlserver.setup)
    • Re: Data Load
      ... you want to load the data ... independently into a staging table for each of your jobs. ... > We have a data-warehouse server which loads data from different databases ... > databases and writing to same table. ...
      (microsoft.public.sqlserver.server)
    • Re: Data Load
      ... you want to load the data ... independently into a staging table for each of your jobs. ... > We have a data-warehouse server which loads data from different databases ... > databases and writing to same table. ...
      (microsoft.public.sqlserver.programming)
    Loading