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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
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.