Informatica power center ...and asked scenario. Olap and oltp.. What are the differences between connected lookup and unconnected lookup? Connected vs Unconnected Lookups Connected Lookup Unconnected Lookup 1. It receives input from the pipeline & participates in the data flow. 1. It receives input from the result of an LKP. 2. It can use both, dynamic and static cache. 2. It can’t be dynamic. 3. It can return more than one column value i.e. output port. 3. It can return only one column value. 4. It caches all lookup columns. 4. It caches only the lookup output ports in the return port & lookup conditions. 5. It supports user-defined default values. 5. It doesn’t support user-defined default values.