DSXchange

Hi,
In DSEE, If I am asked to a create a job either in server or Parallel...What are all the factors that I need to consider to choose between the 2 types of jobs?


Please help.

Thanks

Lalitha

First thing is to find out the volume(number of records) you are dealing with. For small volumes Server job are better than Parallel jobs because of the overhead Parallel job has.

Parallel jobs main strength is to run fast for large volume of records and it is scalable.

In addition to pure volume and performance you could ask yourself:

1. Is there complex transform work to be done, particularly with strings
2. Is there a project-level or system-level restriction on server or px jobs?
3. Is there going to be a skill-set for maintaining the type of job you write in the future?
4. Does the job require some resource not available in one or the other flavour?