RE: What are the different Lookup methods used in Informatica?
connected lookup will receive input from the pipeline and sends output to the pipeline and can return any number of values.it does not contain retun port . Unconnected lookup can return only one column. it containn return port.
RE: What are the different Lookup methods used in Info...
Connected transformation is connected to other transformations or directly to target table in the mapping. An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation.
Connected lookup receives input values directly from mapping pipeline whereas UnConnected lookup receives values from: LKP expression from another transformation. Connected lookup returns multiple columns from the same row whereas UnConnected lookup has one return port and returns one column from each row. Connected lookup supports user-defined default values whereas UnConnected lookup does not support user defined values.
RE: What are the different Lookup methods used in Info...
My dear ravi,
unconnected Lookup never use Dynamic cache it use only Static cache. and one thing more may be it happend by mistake but u should know that if u r giving answer it will read by many people who can be freshers and he has not much knowledge regarding cache. so it will give wrong effect to them.
RE: What are the different Lookup methods used in Info...
Hi!Lookups are two types: 1) Connected 2) Unconnected
Connected is further two types 1) Static 2) Dynamic connected lookup is used while returning single or multiple returning values, but unconnected can return only single return value. static and dynamic are the caches that can be configured during the session. in dynamic inserts and updates occurs in cache during the session while in static there will be no such process. remember whenever you use dynamic lookup, you have to place an update strategy transformation before the target table.
