Home » Developer & Programmer » Warehouse Builder » difference between connected / unconnected lookup
difference between connected / unconnected lookup [message #132847] Tue, 16 August 2005 07:43 Go to next message
gautamvv
Messages: 254
Registered: June 2005
Senior Member
what are the differences between connected and unconnected

lookups? in what scenarios should we use

both?


also please let me know when to use dynamic lookup cache?

and static lookup cache?




Re: difference between connected / unconnected lookup [message #137993 is a reply to message #132847] Mon, 19 September 2005 06:00 Go to previous messageGo to next message
kiran
Messages: 503
Registered: July 2000
Senior Member
Connected lookup tranformation gets the input directly from the mapping pipeline, where as unconnected lookup transformation gets the input from another expression transaction.

--Kiran.


Re: difference between connected / unconnected lookup [message #158968 is a reply to message #137993] Wed, 15 February 2006 04:49 Go to previous message
krsoujanya
Messages: 8
Registered: July 2005
Junior Member
the differences between connected and unconned lookups are as follows:
Connected lookup:- 1. Receives input values directly from the pipe line.
2. You can use a dynamic or static cache.
3. Cache includes all lookup columns used in the mapping.
4. Support user defined default values.
Unconnected lookup:-
1. Receives input values from the result of an lkp expression in another transformation.
2. You can use a static cache.
3. Cache includes all lookup out put ports in the lookup condition and the lookup/return port.
4. Does not support user defined default values.

the main advantages of the unconnected lookup is if suppose u can use the same lkp transformations 2 or more times in a same mapping its waste of time. in that situations, we can create unconnected lkp transformation and call that expression wherever u want.
Previous Topic: Informatica sequence nightmare!
Next Topic: how to import an access mdb to oracle warehouse builder
Goto Forum:
  


Current Time: Fri Aug 01 19:33:15 CDT 2014

Total time taken to generate the page: 0.06605 seconds