Why dont we have look-up stage in Datastage Server jobs

RohanSharma · Post by **RohanSharma** » Fri Feb 23, 2007 6:18 am

Hello alll,

I have a basic question for which i could not find an answer.

Why in datastage we dont have Look=up stage ina server job ?

I tried to figuer out but could'nt find an answer to it .
Can someone throw some light on it ??

ArndW · Post by **ArndW** » Fri Feb 23, 2007 6:37 am

In DataStage server jobs, the lookup is done via a reference link in a transform stage.

DSguru2B · Post by **DSguru2B** » Fri Feb 23, 2007 7:51 am

Hashed file stage is present in server jobs for lookups.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 23, 2007 3:32 pm

Ultimately the answer is that the vendor elected to have server jobs perform lookups one way (Transformer stage) and to have parallel jobs do it a different way (Lookup stage). The parallel Transformer stage does not support reference inputs.

As to why, only the vendor could answer that definitively.

RohanSharma · Post by **RohanSharma** » Sat Feb 24, 2007 1:18 am

yes I'm aware of the fact that lookup is done via a transformer stage .
Also to add to this we can always perform look up in a transformer using datasets too.
but My question is that why at all datastage makers decided to provide this functionality in a transformer stage and did not allow look up stage in a server job.
Is this got something to do with the performance of a server job.

ray.wurlod · Post by **ray.wurlod** » Sat Feb 24, 2007 5:21 am

It is NOT possible to perform a lookup in a Transformer stage using Data Sets. The parallel Transformer stage does not support reference inputs. At all.

chulett · Post by **chulett** » Sat Feb 24, 2007 7:21 am

RohanSharma wrote:but My question is that why at all datastage makers decided to provide this functionality in a transformer stage and did not allow look up stage in a server job.

Because they are different products and different paradigms. Ascential built the Server product from the ground up, and later acquired the PX technology and folded it into the product line.

DSguru2B · Post by **DSguru2B** » Sat Feb 24, 2007 7:51 am

Two different animals. I like to put it that way

RohanSharma · Post by **RohanSharma** » Sun Feb 25, 2007 10:43 pm

ray.wurlod wrote:It is NOT possible to perform a lookup in a Transformer stage using Data Sets. The parallel Transformer stage does not support reference inputs. At all. ...

I know that I was not clear in stating my earlier comments,but i was referring to server jobs only .

I know that a transformer doesnot support referrence links in a parallel job .

But in a parallel stage we can perform a lookup using the look up stage and datasets always.

kumar_s · Post by **kumar_s** » Mon Feb 26, 2007 2:17 am

If you are referring to Server jobs, Dataset is not available in Server jobs.

DSguru2B · Post by **DSguru2B** » Mon Feb 26, 2007 2:00 pm

RohanSharma wrote: But in a parallel stage we can perform a lookup using the look up stage and datasets always.

And thats how the px engine was designed to perform. Server jobs dont have lookup stage and datasets, period.