Server to Parallel job conversion

atul9806 · Post by **atul9806** » Tue Oct 16, 2012 8:04 am

Hi All
I know there is no way to convert the Server job to Parallel job in a single click, we have to redesign the job again. But I want your suggestions in this task ?
What are the things for which I have to consider/take care ?

rohitagarwal15 · Post by **rohitagarwal15** » Tue Oct 16, 2012 9:56 am

You can create server shared container and can use that in your parallel job if this matches your requirement otherwise go for redesigning the job in parallel but some of server job stages are not available in parallel job so you need to tke care of that.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 16, 2012 3:13 pm

The first thing to consider is whether it makes sense to undertake the "conversion". Server jobs are not going away. And they are more efficient for small data volumes than are parallel jobs.

Other than that, the best way to convert is, indeed, to analyze the logic of the server job and to design a parallel job from the ground up to effect the same logic.

oracledba · Post by **oracledba** » Wed Oct 17, 2012 3:17 pm

Some things to consider when doing Sever to Parallel job conversion

-Datastage parallel jobs can run in parallel on multiple nodes. Server jobs do not run on multiple node.
-Parallel jobs support partition parallelism(Round robin,Hash,modulus etc.), server jobs don't support this.
-The transformer in Parallel jobs compiles in C++. In server jobs, the transformer is compiled in Basic language.
-Transformer functions are few in parallel jobs vs in server jobs more Transformer functions available
-In parallel jobs look up stage is available. In server jobs no look up stage is available so you need to do the logic using a transformer which serves as a look up in server jobs
-server job runs on one node whereas parallel job runs on more than one node.

atul9806 · Post by **atul9806** » Sat Oct 20, 2012 3:46 am

Thanks man
Any more suggestions guys...

chulett · Post by **chulett** » Sat Oct 20, 2012 7:23 am

I'm just going to echo what Ray said but add that you should think of this as if you were converting from a completely different tool to another, which basically you are. Make sure you thoroughly understand what the Server job does and then build an equivalent Parallel job. Much the same as if you'd started from an Informatica or Pentaho job... emulate what the old tool did but leverage the strengths of the new tool.

I don't feel there's anything special to "consider / take care of" during this, just all of the normal things you have to consider when building a Parallel job any day of the week.

ray.wurlod · Post by **ray.wurlod** » Sat Oct 20, 2012 12:52 pm

Or, there are several organizations who will do this for you for a fee. And you probably have to agree to your job designs being offshored.

DSXchange

Server to Parallel job conversion

Server to Parallel job conversion

Re: Sever to Parallel job conversion