Posted: Mon Jun 30, 2003 9:27 am
Emma
I assume you are talking about batch jobs if I understand your question. In a batch job when you build it then it has a line like:
ErrCode = DSWaitForJob(hJob1)
You can move this line and the following code to make jobs run at the same time otherwise the jobs run one at a time and the batch job waits for that job to finish before starting the next job.
If you are talking about within one job then if a stage is both input and output then it waits for the stage to write out its data before starting the next part. In other words make one the end of one stage the start of the next transform.
stage1->trans1->stage1->trans2->stage2
instead of:
stage1->trans1->stage1
stage2->trans2->stage2
To force an order then separate this job into 2 jobs and control it in the batch job.
like:
Job1:
stage1->trans1->stage1
Job2:
stage2->trans2->stage2
Thanks Kim.
Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com
I assume you are talking about batch jobs if I understand your question. In a batch job when you build it then it has a line like:
ErrCode = DSWaitForJob(hJob1)
You can move this line and the following code to make jobs run at the same time otherwise the jobs run one at a time and the batch job waits for that job to finish before starting the next job.
If you are talking about within one job then if a stage is both input and output then it waits for the stage to write out its data before starting the next part. In other words make one the end of one stage the start of the next transform.
stage1->trans1->stage1->trans2->stage2
instead of:
stage1->trans1->stage1
stage2->trans2->stage2
To force an order then separate this job into 2 jobs and control it in the batch job.
like:
Job1:
stage1->trans1->stage1
Job2:
stage2->trans2->stage2
Thanks Kim.
Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com