Using sequence in Datastage Sequencer

[avi21st]

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:

Code: Select all

    
                             ---------->Job A
                             ----------->Job B
Job 1 --------> Sequence     ----------->Job C
                             ----------->Job D

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.

____________________________________________________

[ray.wurlod]

Except that your terminology is confused (you are using a Sequencer in a Job Sequence) the answers are yes, yes and yes.

[chulett]

And yes.

[avi21st]

And yes.

I had to raise this question- as I needed support for my concept to show my team. Thanks for the help.