how to get server transformer stage in parallel jobs?

mallikharjuna · Post by **mallikharjuna** » Wed Nov 19, 2008 8:30 am

i have few routines in datastage server jobs, i have one requirenment in parallel jobs to use those routines? how to get the server tansformer stage in paralle jobs?

Regards
Malli

srimitta · Post by **srimitta** » Wed Nov 19, 2008 8:45 am

Open Parallel Job -->expand Processing Palette --> right click & choose Customization --> Customize..--> under repository item & under Stage types expand Parallel and highlight BASIC Tranformer and move it to right side window (Current Palatte groups and shortcut items:).

mallikharjuna · Post by **mallikharjuna** » Wed Nov 19, 2008 8:53 am

Thanks srimitta.

mallikharjuna · Post by **mallikharjuna** » Wed Nov 19, 2008 8:58 am

is it posiible to use the server transformer with parallel job stages?

DSguru2B · Post by **DSguru2B** » Wed Nov 19, 2008 9:17 am

Yea, but it will run in sequential and not in parallel mode.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 19, 2008 1:32 pm

Not true. The BASIC Transformer stage can run in parallel, though every node on which it executes must be on the (a) machine where the DataStage server engine is installed.

You can also include server shared containers in parallel jobs, subject to certain restrictions that are documented in Chapter 2 of the Parallel Job Developer's Guide - this is another way to incorporate server Transformer stage.

The difference is that a BASIC Transformer does not perform lookups, while a server Transformer can.

In any event, try not to do any of these things. Figure out how to do what you want to do using native parallel stage functionality as much as possible.

kandyshandy · Post by **kandyshandy** » Wed Nov 19, 2008 1:50 pm

Ray, So you mean to say that BASIC transformer stage is same as Server Transformer stage. I was thinking that BASIC transformer is a PX stage.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 19, 2008 1:51 pm

Since I pointed out the difference between BASIC Transformer and server Transformer in my post, how can you claim that I said they're the same?!!

Premium membership is inexpensive, at less than 30c (Rs12) per day, and helps to fund the hosting and bandwidth costs incurred by DSXchange.com.

kandyshandy · Post by **kandyshandy** » Wed Nov 19, 2008 2:34 pm

The question was "is it possible to use server transformer in parallel job?"

DSGuru told that it can be used and it will be executed in sequential mode.

Then you started with "Not true. BASIC transformer can run in parallel" So i ended up asking whether BASIC transformer is nothing but Server transformer?

Anyways, hope the poster is clarified.

kandyshandy · Post by **kandyshandy** » Wed Nov 19, 2008 2:37 pm

Ray, since i could not see your complete posting, the confusion happened i guess. I will become a premium member soon to take a look.

chulett · Post by **chulett** » Wed Nov 19, 2008 2:38 pm

While similar, they are not the same stage.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 19, 2008 5:05 pm

... and I did specify how you can get a server Transformer stage into a parallel job as well as talking about the BASIC Transformer stage.

stefanfrost1 · Post by **stefanfrost1** » Thu Nov 20, 2008 1:52 am

I am not sure that we did something really wrong, but we had a consultant which implemented transformations in parrallel jobs using a BASIC tarnsformer and we had problems with all those jobs every 3-5 run, where the job would fail due to broken pipes. I spent 4-6 month recoding every job into parallel transformers and we got runtime stability....

ray.wurlod · Post by **ray.wurlod** » Thu Nov 20, 2008 3:43 am

The very point I made at the end of my first post in this thread.