Using sequence in Datastage Sequencer
Posted: Thu Apr 20, 2006 7:38 pm
I have a question on Datastage sequence. Just for information- we are working on Datastage server edition 7.5
Say I have designed a job sequence in this fashion:
My first question is should Job A, Job B, Job C and Job D can run parallely
Now my second question is now if Job A, Job B, Job C and Job D are all extracting from the same table. Would this all these four job run in parallel.
My third question is- would there be benefit in the above structure. I mean say if the Job A takes 1 hour, Job B takes 1 hour, Job C takes 1 hour and Job D takes 1 hour.
In the above Job sequence they together can take 1 hour-Is it possible. Would take be a sharing of processer cycle.
By this I mean- If I had Job A then Job B then Job C and then Job D- would this take more time.
I believe the above design would be faster- Please suggest.
____________________________________________________
Say I have designed a job sequence in this fashion:
Code: Select all
---------->Job A
----------->Job B
Job 1 --------> Sequence ----------->Job C
----------->Job DMy first question is should Job A, Job B, Job C and Job D can run parallely
Now my second question is now if Job A, Job B, Job C and Job D are all extracting from the same table. Would this all these four job run in parallel.
My third question is- would there be benefit in the above structure. I mean say if the Job A takes 1 hour, Job B takes 1 hour, Job C takes 1 hour and Job D takes 1 hour.
In the above Job sequence they together can take 1 hour-Is it possible. Would take be a sharing of processer cycle.
By this I mean- If I had Job A then Job B then Job C and then Job D- would this take more time.
I believe the above design would be faster- Please suggest.
____________________________________________________
