Page 1 of 1
Regarding Connected and Unconnected lOOKUPS
Posted: Mon Jun 11, 2007 11:08 am
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
Re: Regarding Connected and Unconnected lOOKUPS
Posted: Mon Jun 11, 2007 1:09 pm
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
Posted: Mon Jun 11, 2007 1:11 pm
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.
Posted: Mon Jun 11, 2007 4:01 pm
by ray.wurlod
DB2 or Oracle Enterprise stages support sparse lookup.