| Connected lookup | Unconnected lookup |
| Can use static or dynamic cache | Uses static cache |
| Input is directly received from a pipeline | Input is received as a result of a :LKP expression in some other transformation |
| Provides support for user-defined values (default) | No support for default user-defined values |
| If there are no matching results for the lookup condition, the service returns a default value | A NULL value is returned if there is no match |