Hi All,
I have four mappings to load four different tables which are independent of each other, and each has different source
TableSrc1 --------------> TableTgt1
TableSrc2 --------------> TableTgt2
TableSrc3 --------------> TableTgt3
TableSrc4 --------------> TableTgt4
Now I want to know what and how different is it when I create 4 different jobs for each mapping and when I create 1 job which has all the four mappings in it?
Does creating 1 job for all the four mappings give me any performance benifit?
Thanks!!!!!
Rai
multiple standalone jobs in one job - any performance gain?
Moderators: chulett, rschirm, roy
Re: multiple standalone jobs in one job - any performance ga
Welcome! :D
![Evil or Very Mad :evil:](./images/smilies/icon_evil.gif)
No. In my opinion, there are no 'pros' and all 'cons' to this approach. If there are any dependancies on any of these jobs, you now need to wait for all jobs to complete. The bigger issue to me is restartability - one load has a problem and you need to rerun all four.raiva1 wrote:Does creating 1 job for all the four mappings give me any performance benifit?
![Evil or Very Mad :evil:](./images/smilies/icon_evil.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 27
- Joined: Wed Jan 03, 2007 1:29 am
Re: multiple standalone jobs in one job - any performance ga
Having 4 load in the same job will not improve performance.
But for performance have 4 loads in 4 different jobs and in the sequencer make them to run in parallel. This will improve the performance a lot.
But for performance have 4 loads in 4 different jobs and in the sequencer make them to run in parallel. This will improve the performance a lot.
Hemachandra
Well... running them in a Sequence job or in a single Server job with no dependencies between the job streams will both run all four 'in parallel'. It's just that you have restartability and other options available in the Sequence job that you don't have in your original approach.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers