Regarding Connected and Unconnected lOOKUPS

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vijaykumar
Participant
Posts: 228
Joined: Tue Oct 03, 2006 7:08 pm

Regarding Connected and Unconnected lOOKUPS

Post by vijaykumar »

Hi Gurus,

I have worked with lookup transformation, but never came across connected and unconnected lookup.Where does we use such type of transformation.

cheers;
Vijay
Top
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: Regarding Connected and Unconnected lOOKUPS

Post by gateleys »

vijaykumar wrote:Hi Gurus,

I have worked with lookup transformation, but never came across connected and unconnected lookup.Where does we use such type of transformation.

cheers;
Vijay
I thought those are Informatica terms.

gateleys
Last edited by gateleys on Mon Jun 11, 2007 1:29 pm, edited 1 time in total.
Top
uegodawa
Participant
Posts: 71
Joined: Thu Apr 27, 2006 12:46 pm

Post by uegodawa »

I think unconnected lookup is 'In Memory Lookup' and connected lookup is 'Direct Lookup or Sparse Lookup'. As far as I know, this kind of lookups are available for DB2 only.
Read more about : Parallel Job developers guide
DB2/UDB Enterprise Stage.
Thanks,
Upul
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

DB2 or Oracle Enterprise stages support sparse lookup.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”