DSXchange

I am trying to rewrite a server job to parallel job for performance improvement.
Currently the server job calls 3 server routines. I have 2 options here.

1. Create Parallel routines and call them in the Parallel transformer
2. Use a BASIC transformer and continue to use the
server routines. In this case 1 would need 2 BASIC transformers based on 2 constraints.

Would the usage of BASIC transformer in a parallel job would lower the performance considerably.
I am curious as the original ask is to better the performance of the current job.

First off, it is not always the case that parallel is faster than server. For small data volumes a server job can be finished before a parallel job has completed its startup!

Second, whether "usage of BASIC transformer in a parallel job would lower the performance considerably" would depend on a number of factors:
(a) what do you mean by "performance"?
(b) what do you mean by "considerably"?
(c) what is your topology (in particular SMP versus MPP or grid)?

Third, why would you need two BASIC Transformer stages? Why couldn't you use just one?

Thanks Ray. I don't have a Premium membership currently. I may take it in the future. May I request to please add the missing parts of the reply. Thanks.